add numbers but ignore text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

1vagrowr - 21 Nov 2005 16:31 GMT

I can't figure out how to phrase this in question form so here's what I want
to do:

A1 contains text "Week 1". I want the next 51 cells to display exactly the
same thing but with the next sequential number (Week 2, Week 3, etc.). Can I
create a formula to ignore the text when calculating but display it as well?

Thanks.

Reply to this Message

John Vinson - 21 Nov 2005 17:22 GMT

>I can't figure out how to phrase this in question form so here's what I want
>to do:
[quoted text clipped - 4 lines]
>
>Thanks.

Since you're talking about Cell A1 and the like, I would guess that
you're using Excel, right?

If so please scroll down the list of newsgroups in the lower left of
your screen and repost the question in an Excel forum. This newsgroup
is for a different program, Microsoft Access.

John W. Vinson[MVP]

Reply to this Message