Excel directory formula question?
So I have this formula:
='C:\Users\XXX\Documents\Debug\F1\203\…

I have to replace the "203" folder in the file directory for 60 rows about 30 times with different folders. I don't want to do this manually :s
Is there a formula to allocate a cell which Excel will reference for the name of the folder it should be going to for the file?