Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot get the column to total with =sum 7
How do I enter a conditional formula? 2
Comparing two dates 1
Multiple Conditional tests with Sumproduct 6
Excel VBA 1
Nesting SUMIF within SUMPRODUCT 10
Help with 'If' function 3
Excel VBA - Problem with Closing Print Preview 0

Back
Top