Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
schieb
 
Posts: n/a
Default How to use literal quotes with concatenation


I have a cell that I would like to build that looks like this:
-c:1006 -u:PC\USER -i:"D:\Program Files\SomeApp\My Server\file.txt"

The only variable field is 1006 which is pulled from column B.

So this is how it's setup:
="-c:"&(B7)&" -u:PC\USER -i:D:\Program Files\SomeApp\My
Server\file.txt"

However, I need the quotes to show up. I have tried '" (single quote
double quote) but that gives errors. The only way around it is to put a
quote in a place holder cell i2 then use:

="-c:"&(B4)&" -u:PC\USER -i:" & $I$2 & "D:\Program Files\SomeApp\My
Server\file.txt"& $I$2 &""

Isn't there a simple way to negate the quote so I can keep the formula
within the one cell and not have to reference another one? Thanks!


--
schieb
------------------------------------------------------------------------
schieb's Profile: http://www.excelforum.com/member.php...o&userid=31168
View this thread: http://www.excelforum.com/showthread...hreadid=508289

  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default How to use literal quotes with concatenation


Here's a couple of ways:

1 - use 4 double quotes """" to get a single " double quote
or
2 - use CHAR(34) which is the code for a double quote

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=508289

  #3   Report Post  
Posted to microsoft.public.excel.misc
schieb
 
Posts: n/a
Default How to use literal quotes with concatenation


Ah, thank you very much. It appears doube quotes give you the single
quote though?

="-c:"&(B2)&" -u:DOMAIN\USER -i:""D:\Some PAth\client.txt"""
results:
-c:ACOMPUTER -u:DOMAIN\USER -i:"D:\Some PAth\client.txt"

Perfect, Thanks.


--
schieb
------------------------------------------------------------------------
schieb's Profile: http://www.excelforum.com/member.php...o&userid=31168
View this thread: http://www.excelforum.com/showthread...hreadid=508289

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quotes around fields in CSV SWMagic Excel Discussion (Misc queries) 1 January 19th 06 10:32 PM
Can I format a cell to include quotes " " Speed2772 Excel Worksheet Functions 2 December 13th 05 09:11 PM
Triple Quotes when saving to *.csv D Excel Discussion (Misc queries) 2 December 4th 05 07:06 AM
Add or delete symbols Stock Quotes Tom_in_Jersey Excel Discussion (Misc queries) 0 August 26th 05 07:06 PM
why are there quotes in my exported text file? Gordon Excel Discussion (Misc queries) 2 February 16th 05 07:59 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"