Sum a cell with both numbers and alpha text

Closed
sherbag Posts 2 Registration date Tuesday October 28, 2014 Status Member Last seen October 31, 2014 - Oct 28, 2014 at 01:03 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2014 at 02:00 AM
Is there a way to add multiple cells that contain numbers but also contain alpha text?

3 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Oct 30, 2014 at 03:57 AM
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
0
sherbag Posts 2 Registration date Tuesday October 28, 2014 Status Member Last seen October 31, 2014
Oct 31, 2014 at 11:33 AM
SUE 7.67
MARY 7.67
TINA 7.67
$3,221
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 1, 2014 at 02:00 AM
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
0