| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating text in a cell | Excel Worksheet Functions | |||
| Separating Data in one cell to multiple cells | Excel Discussion (Misc queries) | |||
| separating cells with text | Excel Discussion (Misc queries) | |||
| separating text from cells | Excel Discussion (Misc queries) | |||
| Separating information in one cell into several cells | Excel Discussion (Misc queries) | |||
Threaded Mode
