DataMystic

Hello

I need to search alot Excel Files for UNC Paths, and later replace them with relative ones.

My Question is, how is the best Search Expression to locate all UNC's?

Thank you
Tobias Kopelke

You'll need to know where the files are moving to.

Just search for

\\servername\path

and replace with

..\..\path , with the number of ..\ depending on the folder depth. This will get very messy.