Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to force uppercase
Hey Everybody,
Question for you all ... i want to be able to set a column to force uppercase from another tab in the same worksheet ... this is what i have ... =UPPER(ACTIVE!A4:A32) where active is the name of tab i want this to take place ... let me know ... Thanks, Ryan |
#2
|
|||
|
|||
how to force uppercase
The problem is i get "VALUE" when i do this ... it works if i put it in the
same tab ... but wont pull from the other ones. Somebody tell me if this possible. I have a "VARS" tab where i want my variables. Thanks for the help "Ryan" wrote: Hey Everybody, Question for you all ... i want to be able to set a column to force uppercase from another tab in the same worksheet ... this is what i have ... =UPPER(ACTIVE!A4:A32) where active is the name of tab i want this to take place ... let me know ... Thanks, Ryan |
#3
|
|||
|
|||
how to force uppercase
Did you mean to say: =UPPER(Active!A4) and formula-copy this down to Row 32 ? Ryan Wrote: The problem is i get "VALUE" when i do this ... it works if i put it in the same tab ... but wont pull from the other ones. Somebody tell me if this possible. I have a "VARS" tab where i want my variables. Thanks for the help "Ryan" wrote: Hey Everybody, Question for you all ... i want to be able to set a column to force uppercase from another tab in the same worksheet ... this is what i have ... =UPPER(ACTIVE!A4:A32) where active is the name of tab i want this to take place ... let me know ... Thanks, Ryan -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=483783 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS? | Excel Discussion (Misc queries) | |||
force excel to run in only one process excel.exe | Excel Worksheet Functions | |||
Concatenate & Force argument to End of String-(spsjp) | Excel Worksheet Functions | |||
concatenate, force new line | Excel Worksheet Functions | |||
Force save as | Excel Discussion (Misc queries) |