| 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 | |||
Hybrid Mode
