How can you change an Excel spreadsheet from a combination od Upp.

I want ot change a Excel speadsheet from a combination of upper and lower
case to all uppercase ie all 'Capitols'.

Thanks

Hi!

The function UPPER() will change all alpha characters to upper case. Converse is LOWER() and the Proper() function which capitalises first letters is in the same family

Alf

Try the UPPER function.

If you want to do it programmatically, you will need a macro.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"AllenH" <AllenH@discussions.microsoft.com> wrote in message
news:141F9A90-0845-4F00-AFD9-0C1139903B02@microsoft.com...
>I want ot change a Excel speadsheet from a combination of upper and lower
> case to all uppercase ie all 'Capitols'.
>
> Thanks

Take a look here:

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

In article <141F9A90-0845-4F00-AFD9-0C1139903B02@microsoft.com>,
AllenH <AllenH@discussions.microsoft.com> wrote:

> I want ot change a Excel speadsheet from a combination of upper and lower
> case to all uppercase ie all 'Capitols'.