How can i convert Text Case in EXCEL?
 

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.

=UPPER(A1)

--

HTH

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


"Aleem" wrote in message
...
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.

I could not complete it. Can you step by step guide me to do it.

"Bob Phillips" wrote:

=UPPER(A1)

--

HTH

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


"Aleem" wrote in message
...
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.

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



Aleem wrote:

I could not complete it. Can you step by step guide me to do it.

"Bob Phillips" wrote:

=UPPER(A1)

--

HTH

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


"Aleem" wrote in message
...
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.




--

Dave Peterson

Thanks Dave, i truly appreciate your help.

"Dave Peterson" wrote:

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



Aleem wrote:

I could not complete it. Can you step by step guide me to do it.

"Bob Phillips" wrote:

=UPPER(A1)

--

HTH

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


"Aleem" wrote in message
...
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.




--

Dave Peterson