Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Aleem
 
Posts: n/a
Default 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   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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   Report Post  
Aleem
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Aleem
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 02:08 AM
I want to convert numbers to text in Excel Hannibal Excel Discussion (Misc queries) 2 February 28th 05 04:13 PM
how do I enable "import text file" excel 2002? jw_schmid Excel Discussion (Misc queries) 2 February 9th 05 11:39 PM
How do a convert a "text only (no formulas)" Excel (.xls) file to. Steve Excel Discussion (Misc queries) 1 February 2nd 05 06:55 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"