View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
birdgirl31 birdgirl31 is offline
external usenet poster
 
Posts: 4
Default return second or third word in a cell

If you have several words entered into a cell is there a formula that I can
use in another cell that will return the third word in the orignial cell. The
words are always capitalized and separated with a space.