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
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Which example represents cell data with the date format applied to it? - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel 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
