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!

Isn't there an argument you can supply to the REPLACE function that does it to all occurrences, not just the first one? Let's see.... Nope, guess I just dreamt that. No, wait a minute, here it is; use SUBSTITUTE instead.

SUBSTITUTE(text, old_text, new_text, [instance_num])The SUBSTITUTE function syntax has the following arguments:

• Text Required. The text or the reference to a cell containing text for which you want to substitute characters.
• Old_text Required. The text you want to replace.
• New_text Required. The text you want to replace old_text with.
• Instance_num Optional. Specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.