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

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
>
>

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

"Simon" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>