View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrmnz mrmnz is offline
external usenet poster
 
Posts: 14
Default Removing text before a hypen [-]

I have a list as follows:
timothy - 29
james - 32
brian - 41

I want to get rid of the "timothy - " so just "29" remains.

I have tried Find and Replace using ? - and * - and leaving replace empty.
But it doesn't work. What am I doing wrong?

Thanks.