Adding additional "\" to directory path name
Anyone out there know how to add an additional "\" to a directory path name using a formula?
I am pulling down the current directory path using the =cell("filename",a1) formula. I would like to take this directory path and add an additional "\" to each one in the path name.
For example, i want to take a directory like: C:\desktop\folder name\folder name 2\folder name 3
and make it read as : C:\\desktop\\folder name\\folder name 2\\ folder name 3
I was able to add an additional "\" after the first one only using a REPLACE(g6,find("\",g6),1,"\\").
However, this only takes care of the first "\" and I am not sure how to change the remaining "\"s.
Is there anyway to do this without getting into VBA code?
Much appreciated!
|