MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing the case - all letters in a cell


Posted by Brad B on February 08, 2002 1:42 PM

I created a “ship to” address file by merging info from several databases. Some of these addresses are in lower case. How can I change all letters in a cell to upper case without retyping the entire address?


Posted by Juan Pablo G. on February 08, 2002 1:47 PM

=UPPER(A1) [NT]