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