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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2014 at 02:00 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2014 at 02:00 AM
Related:
- Sum a cell with both numbers and alpha text
- Count if cell contains number - Excel Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- If cell contains date then return value ✓ - Office Software Forum
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 30, 2014 at 03:57 AM
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
"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
sherbag
Posts
2
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 31, 2014
Oct 31, 2014 at 11:33 AM
Oct 31, 2014 at 11:33 AM
SUE 7.67
MARY 7.67
TINA 7.67
$3,221
MARY 7.67
TINA 7.67
$3,221
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 1, 2014 at 02:00 AM
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
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
