Excel Excel 2003 - String Conversion

F

Fraz Qureshi

Joined
Jun 18, 2009
Messages
5
Reaction score
0
Hi!

Does anyone know of a function built into Excel (2003) which allows you to convert all characters in a sheet into uppercase?
I did find an open source macro which does the conversion but due to security settings at work I am unable to use the macro :(
Thanks
 
Fraz Qureshi said:
Hi!

Does anyone know of a function built into Excel (2003) which allows you to convert all characters in a sheet into uppercase?
I did find an open source macro which does the conversion but due to security settings at work I am unable to use the macro :(
Thanks
Click to expand...

You could try this or if you are any good with VBA you could go for this
The VBA would be the better as you wouldn't have to do it for each individual cell..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to enable engineering functions in MS Excel 2000? 3
Macro to copy value in field and insert it into filter 2
Access Access Eliminate Blank Query Results 1
Excel Embedded Excel swap data when opened 0
Excel Excel 2003 Macro 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Conversion - Excel 2003 to Excel 2007 2
Excel Lost data when opening Excel 2003 spreadsheet in Excel 2007 0

Back
Top