Forum

Notifications
Clear all

Case changing

2 Posts
2 Users
0 Reactions
75 Views
(@bonanza-bonanza)
Posts: 6
Active Member
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
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

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
Share: