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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
=Sheet1!A1&" "&Sheet2!A1&" "&Sheet3!A1
Thank you. This worked.