How can i convert Text Case in EXCEL?

A

Aleem

I want to change lower case letter to UPPER case. The example in the excel
assistance is not clear to me. I tried but fail to get the result I want.
 
B

Bob Phillips

=UPPER(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

If your original text is in cell A1, then put Bob's formula in B1 (insert a new
column B if you need to).

If you have a whole column to convert, then drag Bob's formula down the cells.

Then select column B
edit|copy
edit|paste special|values
delete column A
 
A

Aleem

Thanks Dave, i truly appreciate your help.

Dave Peterson said:
If your original text is in cell A1, then put Bob's formula in B1 (insert a new
column B if you need to).

If you have a whole column to convert, then drag Bob's formula down the cells.

Then select column B
edit|copy
edit|paste special|values
delete column A
Click to expand...
 
Top