Re: question about concatenate function displaying quotation marks (Excel 2000)

["Chris Morton" <salt -dot- morton -at- gmail -dot- com>]

This is purely a guess based on my work using WinBatch, but you might try
using apostrophes as the delineator. These would encapsulate the quotation
marks you want to appear as part of your text.

Hence *'*"Hello, World"*'* becomes "Hello, World"

> Chris


On Mon, Oct 27, 2008 at 8:10 AM, Milan Davidovic <milan -dot- lists -at- gmail -dot- com>wrote:

> 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 salt -dot- morton -at- gmail -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/salt.morton%40gmail.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
>
>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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