How is the full name shown in the text... last namecomma first name or
simple first name last name? Are there ever any middle names or titles
(Mr., Mrs, Dr., etc.)?

Rick


"andyK" wrote in message
...
What formula can be used to sepearte information in a cell and put into
several cells? I exported infromation contained in a pdf file into Excel.
In
one of the columns each cell has a full name, Street address, City, state
and
zip. I want to have first name, last name, street address, city, state and
zip extracted and put into different columns. Can this be done?