Hi,
I want help in the following.
I have A1 - 1 22 3 45 5
Like above 5 digit numbers with space between then.
So totally 4 space.
i want the sum of the numbers .
ie for above - 1+22+3+45+5. i have more rows -1l more. so vba is not working properly. i want a formula to extract and sum.
and in the same way. the above to extract and group
b1- 1a&b 2e&h 33a&b 4e&a 55b&h 62e&h
i want to extract a&b e&h e&a b&h numbers separately into a cell grouped.
Extraction to column c,d,e,and so on from b1 by formula
c1 to be 1a&b 33a&b
d1 to be 2e&h 62e&h
e1 to be 4e&a
f1 to be 55b&h
Bookmarks