Hacker News new | ask | show | jobs
by davchana 2137 days ago
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")