![]() |
help parsing multiple text sets from one cell
I have the following cells and need a quick way to parse it into
separate cells. Each name needs to be in firstname lastname and each title in a single cell. The cell contents are not uniform so it is not possible to use the text to columns function. a1= "Dr Jim Jones | Mary Jones | Jim A. Jones" a2= "doctor of medicine | housewife | student at college" any help would greatly be appreciated |
All times are GMT +1. The time now is 06:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com