I need a routine or VBA macro to parse this string or a string like it of vasious number of folders C:\folder1\folder2\folder3\ filename into X number of columns based on how many \ s there are. Can anyone help me?

The reason for a macro/function from right to left is that I can use it in several other areas.
thanks