Quote Marks In A String

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

I want a quote mark to appear adjacent before and adjacent after a wor
in the result of a string arithmetic formula. How is this done?

Thanks in advance,
Chuckles12
 
It looks like 3 quote marks before and 3 quote marks after. ;)
Chuckles12
 
or

=CHAR(34)&"abc"&CHAR(34)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

Using text in a cell in a formula 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
How to limit long text to column width? 7
How to separate contents of one cell into multiple horizontal cell 1
Custom Print Header 7
Dependent "If" formulas 2
Copy and Paste Macro 1
In cell editing 2

Back
Top