Copy info from several cells into one cell [Solved/Closed]

Report
-
 ShkeT -
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. :)


4 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
793
in any empty cell in any sheet
type this formula

=Sheet1!A1&Sheet2!A1&Sheet3!A1
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
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
793
=Sheet1!A1&" "&Sheet2!A1&" "&Sheet3!A1
Thank you. This worked.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!