Computer Magazine & Help with Excel

msaquib

Hi,

Can anyone provide links to website which offer trial on computer magazines?

I have alot of data on Excel which is in lower case. How can I change it to upper case with re-typing it?

Thanks for your help.

Mo

geordie_joe

msaquib wrote: »

Hi,

Can anyone provide links to website which offer trial on computer magazines?

I have alot of data on Excel which is in lower case. How can I change it to upper case with re-typing it?

Thanks for your help.

Mo

Try copying the data and pasting it into a word document, highlight it then from the format menu pick "Change case" and tick Upper Case.

Then copy and paste it back into excel.

If I were you I would paste it into a new excel document, or copy of the original, just to check that it doesn't affect any formulas.

Chippy_Minton

For the Excel question, see http://www.mrexcel.com/archive/Edit/7907.html