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 06, 2013.


For more resources for Microsoft Excel