Copy info from several cells into one cell
Solved/Closed
Related:
- Copy info from several cells into one cell
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Excel formula to subtract one cell from another - Excel Forum
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 12, 2012 at 09:59 AM
Jan 12, 2012 at 09:59 AM
in any empty cell in any sheet
type this formula
=Sheet1!A1&Sheet2!A1&Sheet3!A1
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
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
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 12, 2012 at 09:43 PM
Jan 12, 2012 at 09:43 PM
=Sheet1!A1&" "&Sheet2!A1&" "&Sheet3!A1