Previous Topic Next Topic

Merge information from two cells into one

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

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.

Thanks

1 response

Answer 1 / 1
David
Jul 2, 2010 at 10:10 AM
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.
0

Similar discussions

How to merge WhatsApp backup from old phone to same WhatsApp
WhatsUpWae -
HelpiOS -

1 response
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Short cut to merge cells
rossdavid -
Roopesh -

17 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response