Copy info from several cells into one cell
Solved/Closed
Related:
- Copy info from several cells into one cell
- Excel - Copy info from several cells into one cell - How-To - Excel
- How to move info from one cell to another in excel - Guide
- Auto Copy Row from one Sheet to another via Info in first Cell ✓ - Forum - Excel
- Excel - delete info from a cell found in anot ✓ - Forum - Excel
- Cell colour containing specific info ✓ - Forum - Excel
4 replies
venkat1926
Jan 12, 2012 at 09:59 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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
Jan 12, 2012 at 09:43 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 12, 2012 at 09:43 PM
=Sheet1!A1&" "&Sheet2!A1&" "&Sheet3!A1