I know there's a way to do this, just can't figure it out. I'm trying to REMOVE any uppercase text from cells with mixed case text, e.g., uppercase text at the end of lowercase text that no longer is relevant). Can someone clue me in?
Thanks!
I know there's a way to do this, just can't figure it out. I'm trying to REMOVE any uppercase text from cells with mixed case text, e.g., uppercase text at the end of lowercase text that no longer is relevant). Can someone clue me in?
Thanks!
If you wish to remove all Upper Case text from a cell you can use the LOWER function, for example:
Formula:Please Login or Register to view this content.
This would display the contents of A1 as all lower case. Is this what your're looking to do?
DBY
Or maybe this:
=PROPER(A1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Post SEVERAL examples and show us what results you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
No, I want to go from this:
Franz Klammer Lodge FRANZ
Hotel Columbia HOTEL
Hotel Madeline MADE
Hotel Telluride HOTET
Hyatt Grand Aspen HYATT
to this:
Franz Klammer Lodge
Hotel Columbia
Hotel Madeline
Hotel Telluride
Hyatt Grand Aspen
It looks like you want everything to the left of the LAST word.
Data Range
A B 1 Franz Klammer Lodge FRANZ Franz Klammer Lodge 2 Hotel Columbia HOTEL Hotel Columbia 3 Hotel Madeline MADE Hotel Madeline 4 Hotel Telluride HOTET Hotel Telluride 5 Hyatt Grand Aspen HYATT Hyatt Grand Aspen
This formula entered in B1 and copied down:
=SUBSTITUTE(A1," "&TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",50)),50)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks