Excel Help Needed

Associate
Joined
3 May 2006
Posts
6
I have the current cell in excel with the data input into it with the following format:

Mr DAVIES Michael

As I have over 4000 entries in this format I would like a macro or formula of some sort that will automatically reorganise the cell into the following format:

Michael Davies
or
Surname and Forename into seperate cells.

Also if the MR and MRS etc could be excluded from the output as this is not required.

Thanks!
 
Associate
Joined
18 Oct 2002
Posts
1,159
Location
Bromsgrove
You could use the text to colums function in excel. Select the column containing your data. Then go to the data tab in the toolbar and select text to column. Click next and select spaces. Then click finish. This will seperate the data into seperate colums for you. ;)
 
Back
Top Bottom