=RIGHT(A1,LEN(A1)-FIND(" ",A1))
But I hope you have no middle initials: Winston S Churchill
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Nikki" wrote in message
...
Hello:

I have a name "Jane Doe" that I would like to pull the last name into a
separate column. I have used the mid((e3,1,find(" ",e3,1)-1 formula but it
only gives me Jane. I would like to pull Doe instead. Any help you can
offer
is greatly appreciated.

I would like to avoid "Text to Columns" if possible because I will need to
copy the column into a separate worksheet and was hoping a formula could
do
the trick.

Thanks to you all.