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
Fu,Guo Qing$Prince
Gowan,Louise Marie$Mademoiselle
McGill,James Patrick!Dr
Vinet,Jean Pierre!Mr
Voigt,Claire Antoinette$Madame
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