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
Merging two instagram accounts - Need to make one username
ralphiedee -
HelpiOS -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Merging old and new phone Whatsapp Chat logs
ObsidianDreamer -
HelpiOS -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses