question about concatenate function displaying quotation marks (Excel 2000)

Subject: question about concatenate function displaying quotation marks (Excel 2000)
From: "Milan Davidovic" <milan -dot- lists -at- gmail -dot- com>
To: "techwr-l List" <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Mon, 27 Oct 2008 11:10:12 -0400

I'm setting up an Excel 2000 spreadsheet to create text that I can put
into callouts for a master markup I'm creating. The text is to read:

Replace "xxx" with "yyy".

The sheet has three columns:
Column 1 contains the "xxx" text
Column 2 contains the "yyy" text.
Column 3 contains the formula =CONCATENATE("Replace ",C2," with ",D2,".")

I'm looking for a way to get the formula to put the quotation marks
around the xxx and yyy texts rather than having to put them in Columns
1 and 2

I've tried the advice at this page:

http://support.microsoft.com/kb/141578

But I can't make it work with cell addresses; e.g.

=CONCATENATE("Replace ",""",C2,",""", with ",""",D2,""",".")

doesn't work for me -- perhaps I incorrectly mistyped the formula.

Any ideas?

Thanks.

--
Milan Davidovic
http://altmilan.blogspot.com
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

ComponentOne Doc-To-Help 2009 is your all-in-one authoring and publishing
solution. Author in Doc-To-Help's XML-based editor, Microsoft Word or
HTML and publish to the Web, Help systems or printed manuals.
http://www.doctohelp.com

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity! http://www.helpandmanual.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat


Follow-Ups:

Previous by Author: Re: Grammar gurus: I have a question
Next by Author: SOLUTION FOUND; THANKS Re: question about concatenate function displaying quotation marks (Excel 2000)
Previous by Thread: Re: TECHWR-L Digest, Vol 36, Issue 24
Next by Thread: Re: question about concatenate function displaying quotation marks (Excel 2000)


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads