Excel Question

L

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.
 
N

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
[email protected]
www.nickhodge.co.uk
 
G

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
 
Top