View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarvInBoise MarvInBoise is offline
external usenet poster
 
Posts: 39
Default =TRIM and =PROPER in a nested statement?

I have text data that I import that needs to be trimmed of extraneous spaces
and also converted to upper case; can I do that by nesting =trim and =proper
into one cell? Thanks!
--
Marv Lusk