ExcelBanter - UPPER Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - UPPER Function (https://www.excelbanter.com/excel-worksheet-functions/5780-upper-function.html)

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

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