add numbers but ignore text

1

1vagrowr

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

John Vinson

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.
Click to expand...

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