| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| I want to convert numbers to text in Excel | Excel Discussion (Misc queries) | |||
| how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
