View Single Post
 
Old 10-15-2013, 11:53 AM
jmaxcy jmaxcy is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 6
jmaxcy is on a distinguished road
Default 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!
Reply With Quote