![]() |
Excel
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, whats in Colmn B to the second line, and whats in Colmn C to the third line, but all in the same cell. |
Excel
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 "Josie" wrote: 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, whats in Colmn B to the second line, and whats in Colmn C to the third line, but all in the same cell. |
All times are GMT +1. The time now is 05:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com