Problems appending cells together
 

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

Problems appending cells together
 

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

Problems appending cells together
 

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

Problems appending cells together
 

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

Problems appending cells together
 

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

Problems appending cells together
 

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.