View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BC
 
Posts: n/a
Default How to remove a suffix in excel

type I have the following example data in cells and need to separate the
suffix.
Adelphi Blue7
The suffix may be alpha or numerical but in all cases there is no space
between the main text and the suffix.