Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
75
Views
Topic starter
Could you please help me in changing the cases? There is a part of the whole document, and all of the names and cities are with the wrong cases. What formula could you advise me to fix it?
Posted : 05/10/2021 8:48 am
Hello,
Have you tried with using the PROPER function? It will not work correctly with the state abbreviations though, as you probably want those in uppercase, for that you can use the UPPER function. Article to read about these functions.
Column A
=PROPER(A2)
Column B
=PROPER(LEFT(B2,FIND(",",B2)))&" "&UPPER(RIGHT(B2,2))
Br,
Anders
Posted : 05/10/2021 2:26 pm