change lower-case to upper-case

C

cutyfurby

I input lower-case in the cell and how to return the upper-case.
e.g. I input aaa in the cell and return the AAA
It is not the function upper( ).
 
B

Bernard Liengme

If A1 has the aaa then B1 could have =UPPER(A1) to get uppercase text
But you cannot change the value in the cell A1 with a formula.

If you are doing this to a column of data, you could copy B column and then
use Edit|Paste Special -> Values to replace B's formulas by text and then
delete column A.
 

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
UPPER function 2
Upper case to Lower case 5
Change lower case to upper case 6
Upper Case vs. Lower Case Add-Ins 5
filtering to separate upper & lower case 5
Validate data but then change the entry to upper case 4
upper case letters 4

Top