copying selected text from one column to another

Select column then press Ctrl + H. In the find box enter

name :

and leave the replace box empty

VBA Noob

Originally Posted by annie79

Can anyone help me copy selected text from one cell to another? I have a long column with the text 'name : Joe Blogs' and need to delete the first part of the text 'name :' so I only have the text 'Joe Blogs' remaining in the cell. I have thousands of cells like this, and it will take me ages to delete each manually. Is it possible to do this with a function? please help asap!!

Select the column of data.
go to Data > Text to Columns
check Delimited <Next>
check Others and put : in box <Next> then <Finish>
Text will be splitted in two columns, second column would be your required data.

VBA Noob should mention (which in understood rather) that you should press Replace All at the end.