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

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?

one way:

=A1 & "-" & B1

In article ,
"GNAC SID" <GNAC wrote:

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?

Try in say, C1: =A1&"-"&B1
Copy C1 down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"GNAC SID" <GNAC wrote in message
...
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?