Can you Link 3 cells into 1 in Excel 2003

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

Guest

I need to be able to link 3 cells one containing a country, one with the year
and one with price in to 1 cell is there any way of linking them so that as I
move down the sheet the price changes cell.
 
Assuming you are selecting the cell for the formula as A1 then try
=$B$1&$C$1&D1
 
Thank you this works but how can I get the formatting in the price cell
ie(D1) to stay the same, also how do you make spaces in the information.
 
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

Linking cells in different worksheets 1
Linking cells on different sheets within a workbook. 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
#N/A In Cells 7
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
database extract having 3 common cell betwenn sheets 2
function to download stock prices into Excel with 2007 1
Percentage Increase 13

Back
Top