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.
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.