=MID(A1,FIND(" ",A1)+1,FIND(" ",MID(A1,FIND(" ",A1)+1,999))-1)
--
David Biddulph

"zeilski" wrote in message
...
That helps a little. But what if the starting character and the number of
characters differs?

Sally Joe Johnson
Suzanne Peggy Jefferson

"Don Guillett" wrote:

Look in the help index for
LEFT
RIGHT
MID


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"zeilski" wrote in message
...
I have learned how to show just the left info (ex. - Jane instead of
Jane
Smith) and right info (ex. - Smith instead of Jane Smith), but if there
is
three or more words, how do I show just the middle info?

ex. - I'd like to change Jane Sue Smith to show just Sue