| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
UPPER Function
Hello,
I want to modify this formula to make the text Global Trade all upper case....how do I do this?? =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE))," ",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) Thanx |
|
#2
|
|||
|
|||
|
Since "Global Trade is hard coded in the formula, just type it in
in upper case. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dmorri254" wrote in message ... Hello, I want to modify this formula to make the text Global Trade all upper case....how do I do this?? =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE))," ",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging function | Excel Discussion (Misc queries) | |||
| Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| need to save values from a function before it changes | Excel Worksheet Functions | |||
Linear Mode
