Hi there,
I need a formula that tests for three criteria:
1) if there is a "USD" in the cell return a "USD"
2) if there is a "CAD" in the cell return a "CAD"
3) if there is a "*Q" in the cell return a "*Q"
Otherwise return a "-". The CAD/USD/*Q are not consistently in the same place in the text string.
Thanks for the help!!!
Bookmarks