View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FLAgent FLAgent is offline
external usenet poster
 
Posts: 2
Default Changing Text in a cell

Joel - This almost works. The names are almost all two words, the problem is
when there are only two words in the cell it drops the second word because
there is no space after the second word.

Teethless mama, the data can be in column A. Where does the Criteria_List
go? Or how do I set-up the Criteria_List? Thanks.