Extracting text after symbol in excel

[LauraForiero]

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

<colgroup><col style="width: 159pt; mso-width-source: userset; mso-width-alt: 7753;" width="212"> <tbody>
</tbody>

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

 

[Rick Rothstein]

Looking at all of these different solutions (each of which produces the desired result) kind of makes me wonder what the difference is between FIND and SEARCH.

Can anyone shed some light on this?

FIND does a case sensitive search which, for non-letters will always work because there is no letter casing to worry about... SEARCH does a case insensitive search which for non-letters also doesn't matter. SEARCH also permits wildcard which FIND does not (which is not relevant to the code at hand). I do not know for sure, but FIND seems to have less behind-the-scenes work to do than SEARCH, so I would expect it is (slightly) faster.

EDIT NOTE: Based on Aladin's last message, I guess I have to take back my last sentence above, but I must admit I am surprised to find out that FIND is slower than SEARCH given what seems like less behind-the-scenes processing.

 

[bschwartz]

Thanks Aladin, Rick.

 

[Rick Rothstein]

Thanks Aladin, Rick.

Your post and mine may have crossed "in the ether", so you may not have seen my EDIT NOTE in response to what Aladin posted.