I've got an Excel file with a list of file paths that I need to perform actions on, via batch operation. I figured the best way to do this would be to write a CONCATENATE formula to put together the command for me, copy it down all the rows, and dump the column into a batch file.
However, some of the file paths contain spaces. For a batch command to work on these properly, I need to encase the path in quotes. However, any time I try to put the quotes into the CONCATENATE formula, they either don't make it into the end result or the cause the formula to error out. How can I resolve this?
For example, given:
What CONCATENATE formula would put the following into C2:
COPY "C:\My Files\*.*" "D:\My Backup\*.*" /Y