Macro for suppressing file name in a path

[JRWeise]

I have a worksheet that includes a column called path with path names for files.

We would like a macro that would create a new column that has that path minus the file name.

As an example, it would take this:

C:\Windows\Help\Windows\ar-SA\virtualpc.h1s
C:\Windows\Help\Windows\cs-CZ\virtualpc.h1s
C:\Windows\Globalization\Sorting\SortDefault.nls

And create a column with this:

C:\Windows\Help\Windows\ar-SA\
C:\Windows\Help\Windows\cs-CZ\
C:\Windows\Globalization\Sorting\

[nimrod]

With this solution you "select" the cells with the paths you want to convert, then run macro, ... the results will be displayed in the next column over.

Please Login or Register  to view this content.

[shg]

Why a macro?

=LEFT(A1, FIND(">", SUBSTITUTE(A1, "\", ">", LEN(A1) - LEN(SUBSTITUTE(A1, "\", "")))))