Copy part of text from on column to another and delete it.

Hi,

I'm trying to copy part of a text from one column (A) into another column (B) and then delete the text I've copied from column A.
Column A looks something like this:

John Johnson - 5R
Rob Robson - 7F
Joe Smith - 9Z

its the part after the - I need.

Thanks in advance.

You can extract the final part using this in B2:

=MID(A2,FIND(" - ",A2)+3,10)

You might need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

You could also use Text-to-Columns with - as the delimiter.

Hope this helps.

Pete