Merge information from two cells into one Closed

Question

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

Configuration: Windows XP / Internet Explorer 6.0

David · Answer

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.

Merge information from two cells into one

1 response

Similar discussions

Subscribe To Our Newsletter!