How to Pull content from 4 cells to 1 cell
Solved/Closed
Maria
-
Aug 10, 2011 at 12:55 PM
TrowaD
TrowaD
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Related:
- How to Pull content from 4 cells to 1 cell
- Excel if 4 cells match then return value ✓ - Forum - Excel
- How to move contents from one cell to another - Guide
- Excel vba clear contents based on cell value ✓ - Forum - Excel
- To easily copy the content of one cell to several other cells in your worksheet you can use ✓ - Forum - Excel
- Clear cell contents based on color ✓ - Forum - Office Software
1 reply
TrowaD
Aug 11, 2011 at 10:28 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Aug 11, 2011 at 10:28 AM
Hi Maria,
Can't figure out your example:
A2=A2/A2/D2 represents sm=12.00/W123/F456
So A2=sm but also A2=12.00 and A2=W123 ???
But to answer your query in general:
To combine the contents of cells make use of the symbols & and " like this:
A2=AAA
A3=BBB
Combine A2 and A3 to display: AAA/BBB
If this answer doesn't solve your query, then please give a clearer example of what you would like to see happen.
Best regards,
Trowa
Can't figure out your example:
A2=A2/A2/D2 represents sm=12.00/W123/F456
So A2=sm but also A2=12.00 and A2=W123 ???
But to answer your query in general:
To combine the contents of cells make use of the symbols & and " like this:
A2=AAA
A3=BBB
Combine A2 and A3 to display: AAA/BBB
=A2&"/"&A3
If this answer doesn't solve your query, then please give a clearer example of what you would like to see happen.
Best regards,
Trowa