How to export to txt and use "-sign
Nice and simple workaround to copy the selection to notepad. But not really
desirable. I prefer to not have any actions outside Excel, so I can further
automate the actions in Excel.
And I already tested to make use of a helper column. But thanks anyway.
"Dave Peterson" wrote:
You could use a helper column (column D??) that contained formulas like:
=a1&" """&b1&""" """&c1&""""
Then copy that column and paste into a notepad file. Then save that file as
something.bat
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""""
--
Dave Peterson
|