I'm trying to combine text into one cell, but for an entire column. Right now I have to add the 'combine' formula one at a time for each cell that needs combined content. How do I make that formula work for each cell in an entire column?
For reference, I'm currently using this: =B2&"_"&C2&".tif"
But again, each new cell has to change from B2 to B3 and C2 to C3 and so on for hundreds of cells. What am I missing?
Bookmarks