Separating text in one cell into two cells
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?
|