In your sheet, you can also do this cell A4: =A1&A2&A3 Then just copy Column A4. Now you don't need to replace tabs or such. Note: This will give you path li

In your sheet, you can also do this cell A4: =A1&A2&A3 Then just copy Column A4. Now you don't need to replace tabs or such. Note: This will give you path like ...SLIDES1, SLIDES2..., SLIDES10 etc. If you want 1,2,10 to be 01,02,03; Use this instead of A2, TEXT(A2, "00")