If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
add numbers but ignore text
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. |
#2
|
|||
|
|||
add numbers but ignore text
On Mon, 21 Nov 2005 08:31:08 -0800, "1vagrowr"
wrote: 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. 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formulas dealing with text data | Bagia | Worksheet Functions | 6 | June 20th, 2005 10:29 PM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |