View Single Post
  #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