Excel 2003 question

[Arcex]

Ok, say you have 2 rediculously large tabs chock full of info, and you want to combine all text in every cell from tab 1 with the text in the corresponding cell on tab 2, other than by going into each cell, copying the text, and going into the matching cell on the other tab and pasting it in along with the existing text.

Did what I just say make any sense whatsoever, and if so is there any way to actually do it?

 

[IReBait]

Hi Arcex,
Do you mean Combining Cell A1 in Sheet1 with Cell A1 in Sheet2 and the same for all other cells?
In the new Sheet enter: =+Sheet1!A1 & Sheet2!A1
This would concatenate text in cell Sheet1!A1 with text in Sheet2!A1.

Then copy the formula to the remaining cells or range that applies.

Might also be a good idea to then replace all the formulas with a Copy and Paste Special to eliminate the formulas for ever cell in Sheet3. The more formulas you have the longer Excel takes to load due to the need to re-calculate.

Hope this helps.