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


--
ChrisL
------------------------------------------------------------------------
ChrisL's Profile: http://www.excelforum.com/member.php...o&userid=37767
View this thread: http://www.excelforum.com/showthread...hreadid=573439

As ALWAYS, post your efforts for comments


--
Don Guillett
SalesAid Software

"ChrisL" wrote in
message ...

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


--
ChrisL
------------------------------------------------------------------------
ChrisL's Profile:
http://www.excelforum.com/member.php...o&userid=37767
View this thread: http://www.excelforum.com/showthread...hreadid=573439

Chris

How are you appending?

A1 = 2
B1 = 0

=A1 & "-" & B1 returns 2-0


Gord Dibben MS Excel MVP

On Sat, 19 Aug 2006 14:36:25 -0400, ChrisL
wrote:


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

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

"ChrisL" wrote:


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


--
ChrisL
------------------------------------------------------------------------
ChrisL's Profile: http://www.excelforum.com/member.php...o&userid=37767
View this thread: http://www.excelforum.com/showthread...hreadid=573439

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.


--
ChrisL
------------------------------------------------------------------------
ChrisL's Profile: http://www.excelforum.com/member.php...o&userid=37767
View this thread: http://www.excelforum.com/showthread...hreadid=573439

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


On Sat, 19 Aug 2006 17:56:35 -0400, ChrisL
wrote:


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.