Autocopy numeric values

[PEP1958]

"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"

[#2]

@PEP1958 

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.