gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hi,
I have a value in cell D2:
Retail A South Pacific TA
My formula is: =UPPER(MID(D2,10,(LEN(D2)-3)))
The result is
I only want SOUTH PACIFIC
I have 100's of rows with varying length of characters. This is simply one example.
Any thoughts?
I have a value in cell D2:
Retail A South Pacific TA
My formula is: =UPPER(MID(D2,10,(LEN(D2)-3)))
The result is
SOUTH PACIFIC TA |
I only want SOUTH PACIFIC
I have 100's of rows with varying length of characters. This is simply one example.
Any thoughts?