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