software

List of names:
Cell A1: Sam A. amp; 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: www.excelforum.com/member.php...oamp;userid=34365
View this thread: www.excelforum.com/showthread...hreadid=541415Hi,

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

quot;ERudyquot; wrote:

gt;
gt; List of names:
gt; Cell A1: Sam A. amp; Sue R. Jones
gt; How can I seperate this string into individula cells?
gt; B1: Sam
gt; C1: A.
gt; D1: Sue
gt; E1: R.
gt; F1: Jones
gt;
gt; Thanks in advance for any assistance.
gt; Rudy
gt;
gt;
gt; --
gt; ERudy
gt; ------------------------------------------------------------------------
gt; ERudy's Profile: www.excelforum.com/member.php...oamp;userid=34365
gt; View this thread: www.excelforum.com/showthread...hreadid=541415
gt;
gt;

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

Biff

quot;Simonquot; gt; wrote in message
...
gt; Hi,
gt;
gt; You can copy these words to txt file first. Then, use excel to open the
gt; txt
gt; file.
gt; Excel will give a 'Text File import wizard', pls choose the delimited with
gt; the Space
gt; Best Regards
gt; Seymon
gt;
gt; quot;ERudyquot; wrote:
gt;
gt;gt;
gt;gt; List of names:
gt;gt; Cell A1: Sam A. amp; Sue R. Jones
gt;gt; How can I seperate this string into individula cells?
gt;gt; B1: Sam
gt;gt; C1: A.
gt;gt; D1: Sue
gt;gt; E1: R.
gt;gt; F1: Jones
gt;gt;
gt;gt; Thanks in advance for any assistance.
gt;gt; Rudy
gt;gt;
gt;gt;
gt;gt; --
gt;gt; ERudy
gt;gt; ------------------------------------------------------------------------
gt;gt; ERudy's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=34365
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=541415
gt;gt;
gt;gt;