View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wally
 
Posts: n/a
Default Separate two words in cell

On sheet2 in cell a1 I have a number and name of a team which is: #1
Wonders. On sheet2 in cell a1, I would like a formula to give me the
name of the team only (Wonders), without the number (#1). Thanks for
your help.
WallyB