LinkBack URL
About LinkBacks
Hi,
How do I take a column with a bunch of names in it and some are typed with ALL CAPS and some are regular text and make it all regular text unless it contains the word "SUPERVALU"? Because SUPERVALU should be ALL CAPS.
Any ideas?
Hi,
How do I take a column with a bunch of names in it and some are typed with ALL CAPS and some are regular text and make it all regular text unless it contains the word "SUPERVALU"? Because SUPERVALU should be ALL CAPS.
Any ideas?
does this work for you
=IF(A1="SUPERVALU",UPPER(A1),LOWER(A1))
Maybe this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
It makes the whole cell lower case instead of "proper case" Most of the column are names, some are the name of an organization and if it's "SUPERVALU" it should stay all caps, but that's the only exception. I'd like the rest of the column if it's not SUPERVALU to be "proper case"... : ) Thanks for your help!!
Thanks AlKey! It worked great, however, there are several "acronyms" on the list I wasn't aware of until checking the column. Any way to catch those with the formula? Some Acronym examples are "IGA", "IBC", "DC", "JBG"...
Without going through the entire column - those were some examples...
Here is another way for lookup of multiple values
Formula:Please Login or Register to view this content.
if you have more words to search you can create a table in one column and replace this part {"SUPERVALU","IGA","IBC","DC","JBG"} with a range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks