Seperating of Text in one cell into two columns

G

Guest

It's been a while... how do I seperate text in one cell into two cells
effectively two columns.

Example

A1 (Column & Row) Last Name, First Name needs to be seperated into
(A1) Last Name (A2) First Name
 
B

Bob Phillips

Data> Text To columns, separator of comma.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

concatenate values 4
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
Seperating information in a cell 9
Easy one for the Pros! 4
seperating data from one cell to multiple cells? 5
Seperate Names on Columns 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Seperating and extracting text from parentheses 2

Top