Copy info from several cells into one cellSolved/Closed

Question

Hello,
Could you please help me solve my issue bellow?
I have several sheets in Excel, i.e. Sheet 1, Sheet 2 and Sheet 3. I wanted that A1 cell from Sheet 1 to copy any value that has both A1 cell from Sheet2 and A1 cell from Sheet 3.
Or this if is possible:
If A1 cell from Sheet2 has any value to insert "text1" into A1 cell from Sheet 1 and if A1 cell from Sheet3 has any value to insert "text2" into A1 cell from Sheet 1.

Thank you very much for your help.

P.S. Sorry for my previous post. I'm new to this forum, still learning all the rules. Please let me know if I'm doing something wrong. :)


Configuration: Windows XP / Firefox 9.0.1

venkat1926 · Answer

in any empty cell in any sheet 
type this formula

=Sheet1!A1&Sheet2!A1&Sheet3!A1

ShkeT · Answer

Thank you for the reply.

Wanted to ask if it's possible to separate the text I receive. Now I receive something like:
texttext1.
Is there a way to receive:
text text1 
?

Thank you

venkat1926 · Answer

=Sheet1!A1&" "&Sheet2!A1&" "&Sheet3!A1

ShkeT · Answer

Thank you. This worked.

Copy info from several cells into one cell

4 replies

Subscribe To Our Newsletter!