Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 30th 05, 12:35 PM
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  
Old March 30th 05, 01:09 PM
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  
Old March 30th 05, 01:23 PM
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  
Old March 30th 05, 02:22 PM
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  
Old April 5th 05, 10:53 AM
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 01:08 AM
I want to convert numbers to text in Excel Hannibal Excel Discussion (Misc queries) 2 February 28th 05 03:13 PM
how do I enable "import text file" excel 2002? jw_schmid Excel Discussion (Misc queries) 2 February 9th 05 10:39 PM
How do a convert a "text only (no formulas)" Excel (.xls) file to. Steve Excel Discussion (Misc queries) 1 February 2nd 05 05:55 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 09:39 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017