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?

=A1&" - "&B1

one way:

=A1 & "-" & B1

In article <018B8827-4277-4C02-81E1-3BEDB61422A0@microsoft.com>,
"GNAC SID" <GNAC SID@discussions.microsoft.com> 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 <at>yahoo<dot>com
----
"GNAC SID" <GNAC SID@discussions.microsoft.com> wrote in message
news:018B8827-4277-4C02-81E1-3BEDB61422A0@microsoft.com...
> 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?