Excel

J

Josie

I have an excel worksheet that in column A, I have a name of a color, in
Column B I have the color id#, and in Column C I have another ID #.
Now in the same workbook, but on the next Sheet. I want to link the
information from Column A to the first line, what’s in Colmn B to the second
line, and what’s in Colmn C to the third line, but all in the same cell.
 
C

CLR

Put this in the cell where you want the result, and format it for "WrapText"

=Sheet1!A1&CHAR(10)&Sheet1!B1&CHAR(10)&Sheet1!C1

hth
Vaya con Dios,
Chuck, CABGx3
 
Top