"Mary" wrote:
Thanks, but I need a little more help. Example A2 = Smith Trustee
Should be A2 Smith & B2 Trustee This is just an example. Where do I
need to fill in the word trustee in the formula below? Thanks Mary

Ahh, pl disregard the earlier responses which were way-off in the interp <g

Maybe just try splicing col A using Data Text to Columns

Try this on a spare copy:
Assuming empty cols to the right of col A
Select col A, then click Data Text to Columns Delimited Next
In step 2, check "Space" Finish
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---