Sep 20 2019 03:03 AM
"A"
John 1
Peter 2
Elvis 3
Joan 4
And so on
I have a lot of data i column A ending with a numeric value. I need to copy the numeric value (NOT the name) to neighbor cell in column "B"
Sep 20 2019 03:11 AM - edited Sep 20 2019 03:13 AM
If the pattern in column A is always a name in single word followed by a space and then a number, assuming your string is in A2, then try this...
=RIGHT(A2,LEN(A2)-FIND(" ",A2))
Or you can also use the Text to Columns feature under the Data tab and use space as a delimiter and your names will remain in column A while the numbers will be extracted into column B.