Seperate column

[Hildo]

I have one column with the following information:

Last-name1 space Last-name2 space Name

The names are of different lenghts.
I have to seperate Last-name1, Last-name2 and Name and put
them in seperate columns. So from one column I have to go
to 3 columns.

Please help.

Thanks in advance.

Hildo

 

[Frank Kabel]

Hi
use 'Data - Text to columns' for this

 

[Gord Dibben]

Hildo

Try Data>Text to Columns>Deleimited by space.

Should work if you have just the three names in the cell(s).

If more, like Van der Sander, Van der Meer, Hildo, you will have to do some
juggling and possibly re-gluing after.

Gord Dibben Excel MVP