Combining data (numeric format) in multiple cells into one cell (t

G

Guest

If you have data in multiple cells that is numeric format, can the
data be combined into one cell as text? Example. Cell A1 is
number of correct answers (9), Cell B1 is number of questions (10).
In cell C1, would like to display data as (9-10)?

Can a formula be created that will automatically do this so as to
eliminate having to type the information?
 

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

Combining cells 2
Combining data from multiple cells into one cell with commas 1
Copy multiple cells to one cell 10
converting text cell to numeric cell 5
Combining multiple cells into one 3
Multiple rows into one cell 8
Combining a string of text 3
How To Have A Cell Be Blank If... 2

Top