How to Pull content from 4 cells to 1 cell [Solved/Closed]

Question

How to Pull content from 4 cells to 1 cell [Solved/Closed]

Report

Maria - Aug 10, 2011 at 12:55 PM
TrowaD

Posts: 2757
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 8, 2021

- Aug 11, 2011 at 10:28 AM

Hello,

How can I pull content from 4 cells to I Cell in a specific format so that I have it displayed like this: sm=12.00/W123/F456,MD=13.00/W456/F789... AND SO ON. So have a spreadsheet with line items that have things like size price and part numbers in one row(A2,B2,C2,D2 and the next row A3,B3,C3,D3) How do I get them to display the content of those cells in the following way: A2=A2/A2/D2,B3=C3/A3/D3,B4=C4/A4/D4,(sm=12.00/W123/F456,MD=13.00/W456/F789)

Thanks!
Maria

How to Pull content from 4 cells to 1 cell
Excel - Clear the contents of specific cells - How-To - Excel
Gta 4 cell phone - How-To - GTA (Grand Theft Auto)
Excel vba clear contents based on cell value ✓ - Forum - Excel
Excel clear cell contents if another cell changes ✓ - Forum - Office Software
Gta 4 setup 0.1 de kalıyor ✓ - Forum - GTA

1 reply

Ask a question

TrowaD · Answer 1 · 2011-08-11T10:28:30-0400

Answer 1 / 1

TrowaD

Posts: 2757
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 8, 2021

462
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

=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

How to Pull content from 4 cells to 1 cell [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!