Spliting a name cell

Morning,

I have got a range of data which is an import from a different system. It basically has various colums imported into excel, i need to split first name and surname. It is imported in the same colum and is seperated by a comma.

EG...

Smith, John
Carter, Bill

I'm struggling finding the formula which search's for the comma and splits the cell.


Can anyone help??

Many Thanks

Originally Posted by rachew

Morning,

I have got a range of data which is an import from a different system. It basically has various colums imported into excel, i need to split first name and surname. It is imported in the same colum and is seperated by a comma.

EG...

Smith, John
Carter, Bill

I'm struggling finding the formula which search's for the comma and splits the cell.


Can anyone help??

Many Thanks

An alternative to a formula would be to use Data>TextToColumns and choose a Delimiter of a comma. This will split the cells up for you.

Richard

Cheers for your help.

It works spot on.

I was doing a version of the second tip by copying the cell into a different spreadsheet and saving it as a .txt, then importing it as a Delimiter of a comma, then copying the 2 cells back into the original spreadsheet but it was a long winded way round!!

Thanks Again