Merge information from two cells into one

Bob - Jul 2, 2010 at 10:01 AM
 David - Jul 2, 2010 at 10:10 AM

I have a workbook that contains two sheets. I want to take numbers from two separate cells in sheet 1 (ie a numerator and denominator) and place them in a single cell in sheet 2 with this structure:

(100 / 100)

I'm not brilliant with formulae so any help or advice would be appreciated.


1 reply

In the cell in sheet two, you would write:

="( "&Sheet1!A1&" / "&Sheet1!A2&" )"

This is the same as writing

=concatenate("( ",Sheet1!A1," / ",Sheet1!A2," )")

Change Sheet1 for your sheet name and A1 and A2 for your cells.