UPPER Function

[Guest]

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)),"",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applications","Global
Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15)))

Thanx

 

[Chip Pearson]

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


message
news:[email protected]...