Seperate data in cells

[sdjames1979]

Hi there

I have an employees name in C1 (Joe Bloggs), how can I seperate them into two cells?

For example

A1 - First Name (Joe)
B1 - Sunrame (Bloggs)

Not sure if this can be done.

Thanks in advance

 

[Joe4]

Use Text to Columns (under the Data menu) using the Space as your Delimiter.

 

[sdjames1979]

Use Text to Columns (under the Data menu) using the Space as your Delimiter.

I love you! :wink:

 

[sdjames1979]

One more thing, do I have to repeat the same 'text to column' procedure for everyone employee on my list, surely not?

 

[Joe4]

With "Text To Columns", you can do a whole, single column at a time.
So if all your names are in one column, just highlight the whole column first, then do the Text to Columns steps.
If they are in multiple columns, you will need to do each column individually.

 

[Jerk24]

Just make sure that you do not have data in the next column, it will replace it. You may need to add a column to account for this.

 

[sdjames1979]

After my last post, I realised how to do it.

Thanks again for your help, much appreciated.