Most valuable professional
  • Hot Topics

Excel Extracting text after symbol in excel

HI Probably simple I just cant figure it out. I have cell content of a variable length string and I need to extract all text after "!" or "$" A Brouillet,Amy Anne!Miss Dupuis,Jean Paul$Monsieur Ethier,Guy!Mr Fu,Guo Qing$Prince Gowan,Louise Marie$Mademoiselle McGill,James Patrick!Dr Robinson,Jacques$Monsieur Vinet,Jean Pierre!Mr Voigt,Claire Antoinette$Madame Wong,Jia$Reverend I know i must use the Right and Find function together but don't know how to. I need 1 single expression for the entire column. thanks in advance

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of October 6, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel