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?

 

[Oyeve]

Originally posted by: 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?

Dunno, came here to see how Excel can have a General Hardware problem.

 

[tw1164]

Use something like this:

=Sheet1!A1 & " " & Sheet2!A1

 

[Arcex]

Originally posted by: Oyeve

Originally posted by: 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?

Dunno, came here to see how Excel can have a General Hardware problem.

I know, I apologize for that but I didn't know where else to post it, the tech support forum doesn't get many visitors and I think this is too technical to be in OT.

 

[xitshsif]

Originally posted by: tw1164
Use something like this:

=Sheet1!A1 & " " & Sheet2!A1

Don't even need the ""
This will do:

=Sheet1!A1 & Sheet2!A1

 

[overclock]

concatenate