Change case in Excel 2

[CEG]

I have columns in Excel, and there is a need to make all the text uppercase. If I copy the column to word and then back again, the height of rows etc is different. Ultimately this will become an import file for a sql table.
Any advice will be greatly appreciated.

 

[NSoulBri]

the quickest solution is to repeat the column and convert to uppercase all in one go

Suppose column A contains your original lowercase stuff.

in cell B1 type the formula =UPPER(A1) and copy down to all relevent rows

column B now contains an uppercase version of column A

Hope this helps
Bri

"Soul music is for life, not just christmas"

 

[xlbo]

And as an add-on - =Lower(A1) will change to lower case and =Proper(A1) will change to Caps and lower case eg Manchester
Geoff