Excel Question

[Lavida]

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.

 

[Nick Hodge]

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 address removed)
www.nickhodge.co.uk

 

[Gord Dibben]

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