I have what I hope will be a nice easy question for you guys... :)
I'm putting together a worksheet for our local sports league. I want to
append the scores from two cells together with a - in between them (e.g.
2-1), which works fine unless the 2nd score is a zero, in which case it
ignores the - (e.g. 20). How can I get it to display the - all the
time?
I can't change the formatting of the cells, because if the score is
blank (i.e. the match is in the future), then the new cell displays the
date of the match.
I hope that makes sense... :) ,
Chris L

Signature
ChrisL
Don Guillett - 19 Aug 2006 19:46 GMT
As ALWAYS, post your efforts for comments

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>
> I have what I hope will be a nice easy question for you guys... :)
[quoted text clipped - 11 lines]
> I hope that makes sense... :) ,
> Chris L
Gord Dibben - 19 Aug 2006 19:49 GMT
Chris
How are you appending?
A1 = 2
B1 = 0
=A1 & "-" & B1 returns 2-0
Gord Dibben MS Excel MVP
>I have what I hope will be a nice easy question for you guys... :)
>
[quoted text clipped - 10 lines]
>I hope that makes sense... :) ,
>Chris L
ChrisL - 19 Aug 2006 22:56 GMT
Gord Dibben Wrote:
> =A1 & "-" & B1 returns 2-0
Bizarrly that IS what I was using, but without the spaces. Having put
the spaces in, it works perfectly.
I knew it'd be simple! :)
Very many thanks Gord,
Chris.

Signature
ChrisL
Gord Dibben - 20 Aug 2006 00:03 GMT
Chris
The only spaces my formula contains are for ease of reading only, not to make it
work.
But happy to hear you're happy.
See Toppers' error-checking formula also.
Gord Dibben MS Excel MVP
>Gord Dibben Wrote:
>>
[quoted text clipped - 8 lines]
>
>Chris.
Toppers - 19 Aug 2006 20:51 GMT
Will this do ...?
=IF(AND(A1<>"",B1<>""),A1 & " - " & B1,"")
Somewhat confused by "if the score is blank (i.e. the match is in the
future), then the new cell displays the date of the match".
HTH
> I have what I hope will be a nice easy question for you guys... :)
>
[quoted text clipped - 10 lines]
> I hope that makes sense... :) ,
> Chris L