Seperate cell string into individual cells
 

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


--
ERudy
------------------------------------------------------------------------
ERudy's Profile: http://www.excelforum.com/member.php...o&userid=34365
View this thread: http://www.excelforum.com/showthread...hreadid=541415

Seperate cell string into individual cells
 

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

"ERudy" wrote:


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


--
ERudy
------------------------------------------------------------------------
ERudy's Profile: http://www.excelforum.com/member.php...o&userid=34365
View this thread: http://www.excelforum.com/showthread...hreadid=541415

Seperate cell string into individual cells
 

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 DataText to Columns
Select Delimited
Click Next
Delimiters: Select space
Click Finish

Biff

"Simon" wrote in message
...
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

"ERudy" wrote:


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


--
ERudy
------------------------------------------------------------------------
ERudy's Profile:
http://www.excelforum.com/member.php...o&userid=34365
View this thread:
http://www.excelforum.com/showthread...hreadid=541415