Splitting Cell Data From One Cell Into Two

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
 
P

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
 
S

Spencer

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

Spence
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using lookup formula using more than one cell 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Entering Multiple References in One Cell 2
VBA Excel partial cell compare to another cell 0
how to calculate a count of checkboxes that have been checked 1
Seperate first and last name within a cell 3
Conditional Formatting 8
Splitting a Cell 2

Top