Generating text surrounded by quotation marks

  • Thread starter AaronQRules (a.k.a. Jeff)
  • Start date
A

AaronQRules (a.k.a. Jeff)

I am looking for a way to make a text string to appear in quotation marks.

For example, if someone types in the text string Titanic in cell A1 I need
to be able to generate in cell B1 the exact text "Titanic" (with the quotes
visible around whatever is types in cell A1)

I can't figure it out. The use of quotation marks in formulae is compounding
the problem. Has anyone else ever solved this mystery.

Jeff
 
J

John Bundy

In B1 ="''" & A1 & "''"
that is a quote " then two ' then quote " at the beginning and end
 
T

T. Valko

Wait 'til you see all these quotes! <BG>

Try it like this:

=IF(A1="","",""""&A1&"""")

That's 4 double quotes on either side of &A1&

--
Biff
Microsoft Excel MVP


"AaronQRules (a.k.a. Jeff)" <AaronQRules (a.k.a.
Jeff)@discussions.microsoft.com> wrote in message
news:[email protected]...
 
D

David Biddulph

=""""&A1&""""
[4 sets of quotes at a time.]
--
David Biddulph

"AaronQRules (a.k.a. Jeff)" <AaronQRules (a.k.a.
Jeff)@discussions.microsoft.com> wrote in message
news:[email protected]...
 
A

AaronQRules (a.k.a. Jeff)

Thanks to all for the help! This works for me for my project!

Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top