LauraForiero
New Member
- Joined
- Oct 6, 2013
- Messages
- 18
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
<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
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