help parsing multiple text sets from one cell

[[email protected]]

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

[kevincollins_1]

Use delimited text with a customer character "|" instead of fixed width.
Unselect the "tab" checkbox when you enter the "|" symbol as your delimeter.

[shg]

Welcome to the forum, Kevin.

This post is three years old. Chances are, it's OBE.