View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?