Excel Help Needed

s1lkster · 10 May 2006 at 16:30

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!

Teifiterror · 10 May 2006 at 16:36

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.

s1lkster · 10 May 2006 at 16:42

thats ammmmmazing, thank you who ever you are

love paul

x x x x x

Teifiterror · 10 May 2006 at 22:30

Told you i would figure it out