# Concatenating text from 3 cells into a usable formula

Hi All!!,

I want to concatenate text in a couple of cells to into a formula to retrieve information from another workbook.

I am able to retrieve the information using a direct formula:

='file:///C:/Users/PB/Documents/Timesheets/517.TimeKeeping.xlsx'#'Job Summary'.B5

but I want to have a concatenating formula, so id have:

a1:file:///C:/Users/PB/Documents/Timesheets/ b1:517.TimeKeeping c1:.xlsx'#'Job Summary'.B5 d1: concetanate a1, b1 and c1 to create a formula to retrieve the data from the other workbook.

I can concetanate using & but this just creates a long text string - how do I turn this into a formula?

Thanks,

PBrooks