How can i convert Text Case in EXCEL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lower-Case Characters 2
Text Lower Case Letter 4
Upper Case vs. Lower Case Add-Ins 5
In Excel, changing a range of cells to all caps. 2
upper case letters 4
Validate data but then change the entry to upper case 4
Change lower case to upper case 6
filtering to separate upper & lower case 5

Back
Top