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

Report
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
-
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

1 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!