Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

Problems appending cells together

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChrisL - 19 Aug 2006 19:36 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.