Hi All

In Word we can change to uppercase by selecting the text then clicking
Shift+F3. What's the equivalent in Excel ??

Many thanks in advance.

Lavida

No such function in Excel, but using a helper column, lets say your data is
in column A, in the first cell of your helper column (say H1), enter

=UPPER(A1)

Copy this down, then copy this data and paste special>values over the data
in column A to kill the formula and delete the helper column

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
www.nickhodge.co.uk


"Lavida" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All
>
> In Word we can change to uppercase by selecting the text then clicking
> Shift+F3. What's the equivalent in Excel ??
>
> Many thanks in advance.
>
>

Lavida

See Nick's post for a cell by cell worksheet function.

To change case on a great whack of cells at once without the function formulas
you could use a macro if you're interested.


Gord Dibben MS Excel MVP


On Sun, 7 Jan 2007 17:13:38 -0000, "Lavida" <(E-Mail Removed)> wrote:

>Hi All
>
>In Word we can change to uppercase by selecting the text then clicking
>Shift+F3. What's the equivalent in Excel ??
>
>Many thanks in advance.
>