Splitting Cell Data From One Cell Into Two

[Spencer]

Hello, suppose you have an address or telephone list in which the first and
last name are not in seperate cells, but in the same cell. I would like to
somehow seperate the first and last name into two seperate cells. Is there
any way to do this automatically?

Thanks, Spence

 

[Pete_UK]

If you have a space separating the two items, you may think about
using Data | Text-to-columns to split the data, specifying <space> as
the delimiter.

Alternatively, you could use a formula to get the left-hand item and
another formula to get the right-hand item, using SEARCH to find which
character is the space.

Hope this helps.

Pete

 

[Spencer]

Thanks for the quick reply. The text to column solution was exactly what I
was looking for.

Spence

 

[Pete_UK]

Glad it worked for you - thanks for feeding back.

Pete