View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How to export to txt and use "-sign

You could enter it into the cell as a formula, like this:

=CHAR(34)&"file name.pdf"&CHAR(34)

and this will give you:

"file name.pdf"

Hope this helps.

Pete


On Aug 7, 2:18*pm, X-Ray wrote:
I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename * * | *filename.pdf * | * * *"file name.pdf"

Export to txt:

rename * * | *filename.pdf * | * * *""""file name.pdf""""