Splitting Cell Data From One Cell Into Two

  • Thread starter Thread starter Spencer
  • Start date Start date
S

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
 
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
 
Thanks for the quick reply. The text to column solution was exactly what I
was looking for.

Spence
 
Back
Top