ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help parsing multiple text sets from one cell (https://www.excelbanter.com/excel-worksheet-functions/43301-help-parsing-multiple-text-sets-one-cell.html)

[email protected]

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