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!