JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I have the below formula:
=UPPER(RIGHT(H7,LEN(H7)-FIND(".")))
I works in finding the period (.) but I need it to stop finding characters before a parenthesis "("
So I am thinking MID/FIND instead of RIGHT/FIND Need it to find period and then take all characters up to left parenthesis "("
Thank you
James
=UPPER(RIGHT(H7,LEN(H7)-FIND(".")))
I works in finding the period (.) but I need it to stop finding characters before a parenthesis "("
So I am thinking MID/FIND instead of RIGHT/FIND Need it to find period and then take all characters up to left parenthesis "("
Thank you
James