Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change lower-case to upper-case
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( ). -- cutyfurby ------------------------------------------------------------------------ cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371 View this thread: http://www.excelforum.com/showthread...hreadid=542928 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change lower-case to upper-case
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. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "cutyfurby" wrote in message ... 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( ). -- cutyfurby ------------------------------------------------------------------------ cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371 View this thread: http://www.excelforum.com/showthread...hreadid=542928 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change lower-case to upper-case
As it IS the function Upper I don't understand the question!
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change lower-case to upper-case
use ASAP utilities...its an ADD IN.
"cutyfurby" wrote in message ... 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( ). -- cutyfurby ------------------------------------------------------------------------ cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371 View this thread: http://www.excelforum.com/showthread...hreadid=542928 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT | Excel Worksheet Functions | |||
How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions |