Sum a cell with both numbers and alpha text
Closed
sherbag
Posts
2
Registration date
Tuesday 28 October 2014
Status
Member
Last seen
31 October 2014
-
28 Oct 2014 à 13:03
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 1 Nov 2014 à 02:00
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 1 Nov 2014 à 02:00
Related:
- Sum a cell with both numbers and alpha text
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- How to delete a cell in word - Guide
- Insert the current date and time in cell a1 ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Cell phone codes - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
30 Oct 2014 à 03:57
30 Oct 2014 à 03:57
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 28 October 2014
Status
Member
Last seen
31 October 2014
31 Oct 2014 à 11:33
31 Oct 2014 à 11:33
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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
1 Nov 2014 à 02:00
1 Nov 2014 à 02:00
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
