| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel formulas with text
I need a formula that will add 1 for each record of a reference number.
exaplme: my first reference number is jn51000001. I need a formula to copy and paste down a good 20,000 cells. I can't use =sum(a1+1) because of the text in it. I desparately need help on a formula that will work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Threaded Mode
