[France]

For example cell B2:B11 contan the following:

Ralph Reinhart, Roadmaster
John Wodehouse, Grounds Manager
Wendy Becker, Treasurer
Jane Bender, Secretary/Treasurer
Cynthia Urick, Sr. Purchasing Agent
Charles Lyon, Manager
Harry Brown, Executive Director
Michele Zimmerman, Business Manager
Andrea Delo, Secretary
Bruce P Meitzler, Operations Manager

I want to have C2:C11 contain the portion before the comma, and D2:D11 to
contain the portion after the comma and space.

Any suggestions?

[Jacob Skaria]

In C2
=TRIM(LEFT(B2,FIND(",",B2)-1))
In D2
=TRIM(MID(B2,FIND(",",B2)+1,LEN(B2)))
and copy that down as required

--
If this post helps click Yes
---------------
Jacob Skaria


"France" wrote:

For example cell B2:B11 contan the following:

Ralph Reinhart, Roadmaster
John Wodehouse, Grounds Manager
Wendy Becker, Treasurer
Jane Bender, Secretary/Treasurer
Cynthia Urick, Sr. Purchasing Agent
Charles Lyon, Manager
Harry Brown, Executive Director
Michele Zimmerman, Business Manager
Andrea Delo, Secretary
Bruce P Meitzler, Operations Manager

I want to have C2:C11 contain the portion before the comma, and D2:D11 to
contain the portion after the comma and space.

Any suggestions?

[Gord Dibben]

DataText to ColumnsDelimited by comma.

Select C2 as the destination in Step 3


Gord Dibben MS Excel MVP


On Wed, 27 May 2009 11:39:30 -0700, France
wrote:

For example cell B2:B11 contan the following:

Ralph Reinhart, Roadmaster
John Wodehouse, Grounds Manager
Wendy Becker, Treasurer
Jane Bender, Secretary/Treasurer
Cynthia Urick, Sr. Purchasing Agent
Charles Lyon, Manager
Harry Brown, Executive Director
Michele Zimmerman, Business Manager
Andrea Delo, Secretary
Bruce P Meitzler, Operations Manager

I want to have C2:C11 contain the portion before the comma, and D2:D11 to
contain the portion after the comma and space.

Any suggestions?