Sum a cell with both numbers and alpha text [Closed]

Report
Posts
2
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 31, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Is there a way to add multiple cells that contain numbers but also contain alpha text?

3 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
what is meant by
"numbers but also contain alpha text"

you have like this

a
s
2
3
f

or

a2
s3
d4

copy few cells of your data
Posts
2
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 31, 2014

SUE 7.67
MARY 7.67
TINA 7.67
$3,221
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
use text to column to separate and text and you can do sum

after text to column it will look like this col A and col B

SUE 7.67
MARY 7.67
TINA 7.67
x $3,221

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!