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