View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zeilski zeilski is offline
external usenet poster
 
Posts: 3
Default Show just middle info of a cell

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