Previous Topic Next Topic

How to Pull content from 4 cells to 1 cell

Solved/Closed
Maria - Aug 10, 2011 at 12:55 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0