The Name is shown in each cell like the following:

First Name Middle Initial Last Name

(There are no commas just a space between First Middle and Last name

"Rick Rothstein (MVP - VB)" wrote:

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?