View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Writing formula to include quote marks in result

"Col ""M"""

--
__________________________________
HTH

Bob

"Valerie" wrote in message
...
I have an if/then formula that depending on the contents of a cell I want
it
to return one of 3 results. The formula works fine, except I want part of
the text result in quotation marks:

Col "M"
Col "N"

etc. Normal thinking in the formula puts it as
,"Col "M"","Col "N""

but this does not work. Any suggestions? Thanks in advance!