troubleshooting Question

How to include quotation marks as text in an Excel formula

Avatar of Steve_Brady
Steve_BradyFlag for United States of America asked on
Microsoft Excel
4 Comments3 Solutions1216 ViewsLast Modified:
Hello,

In Excel (2007), how do you get a quotation mark to be included as text itself rather than its usual role as a text indicator?

For example, suppose you are creating a line of text by combining the text in several cells with various connecting text and the resulting formula includes this:

    ...&B5&"|,|"&C5…

 where the vertical bars (|) represent quotation marks.  In other words, it needs to include the text :

    ","    (quotation mark - comma - quotation mark)


Is there a way to do that?


Thanks

PS  Would the word "concatenate" be appropriate to use somewhere above?  I've seen it before and looked up the definition but I don't really understand the correct usage.  Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros