Seperate cell string into individual cells

E

ERudy

List of names:
Cell A1: Sam A. & Sue R. Jones
How can I seperate this string into individula cells?
B1: Sam
C1: A.
D1: Sue
E1: R.
F1: Jones

Thanks in advance for any assistance.
Rudy
 
S

Simon

Hi,

You can copy these words to txt file first. Then, use excel to open the txt
file.
Excel will give a 'Text File import wizard', pls choose the delimited with
the Space
Best Regards
Seymon
 
B

Biff

Hi!

Try this:

Make sure the columns to the immediate right of cell A1 are empty to be able
to receive the parsed data.

Select cell A1
Goto Data>Text to Columns
Select Delimited
Click Next
Delimiters: Select space
Click Finish

Biff
 

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

Top