| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing formula to include quote marks in result
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Writing formula to include quote marks in result
Try it like this:
=IF(.....,"Col ""M""","Col ""N""") -- Biff Microsoft Excel MVP "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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Writing formula to include quote marks in result
Perfect!! Thanks!!!! You guys are life-savers!
"T. Valko" wrote: Try it like this: =IF(.....,"Col ""M""","Col ""N""") -- Biff Microsoft Excel MVP "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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Writing formula to include quote marks in result
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Valerie" wrote in message ... Perfect!! Thanks!!!! You guys are life-savers! "T. Valko" wrote: Try it like this: =IF(.....,"Col ""M""","Col ""N""") -- Biff Microsoft Excel MVP "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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I add quote marks around cell contents? | Excel Discussion (Misc queries) | |||
| How do I force quote marks when exporting to a csv? | Excel Discussion (Misc queries) | |||
| Quote Marks Through VBA | Excel Discussion (Misc queries) | |||
| Quote marks in Formulas passed from VB Script in Excel | Excel Worksheet Functions | |||
| How to keep quote marks for CSV in excel | Excel Discussion (Misc queries) | |||
Linear Mode
