software

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

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

So this is how it's setup:
=quot;-c:quot;amp;(B7)amp;quot; -u:PC\USER -i:\Program Files\SomeApp\My
Server\file.txtquot;

However, I need the quotes to show up. I have tried 'quot; (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:

=quot;-c:quot;amp;(B4)amp;quot; -u:PC\USER -i:quot; amp; $I$2 amp; quot;D:\Program Files\SomeApp\My
Server\file.txtquot;amp; $I$2 amp;quot;quot;

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: www.excelforum.com/member.php...oamp;userid=31168
View this thread: www.excelforum.com/showthread...hreadid=508289
Here's a couple of ways:

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

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=508289
Ah, thank you very much. It appears doube quotes give you the single
quote though?

=quot;-c:quot;amp;(B2)amp;quot; -uOMAIN\USER -i:quot;quot;D:\Some PAth\client.txtquot;quot;quot;
results:
-c:ACOMPUTER -uOMAIN\USER -i:quot;D:\Some PAth\client.txtquot;

Perfect, Thanks.--
schieb
------------------------------------------------------------------------
schieb's Profile: www.excelforum.com/member.php...oamp;userid=31168
View this thread: www.excelforum.com/showthread...hreadid=508289