Problems appending cells together

[ChrisL]

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

[Don Guillett]

As ALWAYS, post your efforts for comments


--
Don Guillett
SalesAid Software
[email protected]
"ChrisL" <[email protected]> wrote in
message news:[email protected]...
>
> 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]

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
<[email protected]> 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

[Toppers]

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
>
>

[ChrisL]

=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.

[Gord Dibben]

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
<[email protected]> 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.