Hello Excel Gurus,
I'm currently looking for a way to adjust part of a text string. I tried using nested formulas and looked into using VB code but to no avail. Below is the goal I'm trying to achieve..
Before:
Hello world this is a test - Only testing this
After(the goal I want to achieve):
HELLO WORLD THIS IS A TEST - Only testing this
The majority of these terms will change in length but I would like everything to be Uppercase before the "-".
Any help on this would be appreciated!
Assuming the original text is in A1 try this.
=IFERROR(UPPER(LEFT(A1, FIND("-", A1)-1))& MID(A1, FIND("-", A1)-1, LEN(A1)),A1)
If posting code please use code tags, see here.
Hi,
Here is another formula that will do what you want. Put your text in A1 and then this formula will do it.
=SUBSTITUTE(A1,LEFT(A1,FIND("-",A1)),UPPER(LEFT(A1,FIND("-",A1))))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Dear Norie & MarvinP,
Thank You for taking the time for looking into this! Both solutions worked perfectly. Thanks again for taking the time to solve this issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks