Convert one cell into two cells

[1Roberta1]

Hi I was wondering if someone could help me out.

I have been sent a completed excel spreadsheet that consists of 11 columns and 8000 rows.

Column B has been completed with surname and forename. I need to split Column B so that the surname and the forename have different columns. I had considered inserting a column and pasting over the forenames into the new column, however with 8000 rows there is too much room for human error.

Can this process be completed with a formula or something?

I would very much appreciate your assistance with this.

Thanks in advance for your time.

 

[DominicB]

Good afternoon 1Roberta1

...and welcome to the forum!!

This could certainly be done with a formula, but you will need to explain what the format is (eg, Smith Jim or Smith,Jim or Smith, Jim etc).

DominicB

 

[dave3009]

Hi 1Roberta1

Welcome to the board

Perhaps having a look at Text To Columns. Go to Data>>Text To Columns. As you go through the options you will see an option to split at space check that box.

You will need a blank column next to the one containing your name


HTH


Dave

 

[arthurbr]

Welcome to the board
if surname and forename are spearated by a space, comma or anything constant, select col B go to the Data menu-select "Text to columns" and follow the wizard

 

[1Roberta1]

Thank you so much for your very quick responses.

Text to columns is working perfectly.

Thank you again