John 1Peter 2Elvis 3Joan 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"
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...
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.