hi
you might try using text to columns.
on the menu bar....
Datatext to columns...follow the wizzard.

If your have a lot of names of varing lengths, with and without titles, you
may have problems. you may need to group name of similar length and title so
that you can parce the data in blocks or groups. otherwise you may have to do
i one name at a time. also when parcing data, make sure you have enough blank
cells to the right of the data you are parcing because this function will
overwrite data to the right.

regards
FSt1

"dk" wrote:

How can we split the last names to another cell ?
Als if we have Mr & mrs john doe mike how can we split the title ?