hi there,
i have 3 dummy files I am simply trying to join 3 cells on and make them be 1 cell next to it in the output file see attached
so Cell 1a on 123.XLS is "123"
Cell 1a on 456.XLS is "456"
Cell 1a on 789.XLS is yep, you've guessed it "789"
all i want the out put to have is a cell which is "123456789"
Simple right?
:)
Solved! Go to Solution.
Hooray, Thanks Charlie