Previous Topic Next Topic

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

Answer 1 / 4
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
Answer 2 / 4

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
Answer 3 / 4
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 802
=Sheet1!A1&" "&Sheet2!A1&" "&Sheet3!A1
Answer 4 / 4

Thank you. This worked.
Ask a question