Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shannon Shannon is offline
external usenet poster
 
Posts: 53
Default Formulas

Hi again!

I was wondering how I could take the text "ABCD -Text" (in one cell) and
create a formula in another cell so that only "Text" would show up and not
the "ABCD -". The problem so far is that the "Text" is not always the same #
of characters so the RIGHT function will not work.

Any help would be greatly appreciated!
Thanks,
Shannon