| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formulas
I need to create a formula for end use as labels. The info in the first cell
is ABC1107J100 and then I need it to increase by one in each cell after A1, i.e. 100, 101, 102, 103, etc. I then need to print these in Word label format. Please help!!!!!!! Thanks, JMS786 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with formulas
Simply drag it down Mike "JMS786" wrote: I need to create a formula for end use as labels. The info in the first cell is ABC1107J100 and then I need it to increase by one in each cell after A1, i.e. 100, 101, 102, 103, etc. I then need to print these in Word label format. Please help!!!!!!! Thanks, JMS786 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with formulas
Enter the first text in a cell and dra/copy down as required.
ABC1107J100 If this post helps click Yes --------------- Jacob Skaria "JMS786" wrote: I need to create a formula for end use as labels. The info in the first cell is ABC1107J100 and then I need it to increase by one in each cell after A1, i.e. 100, 101, 102, 103, etc. I then need to print these in Word label format. Please help!!!!!!! Thanks, JMS786 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with formulas
This is a brilliant answer, Mike.
"Mike H" wrote: Simply drag it down Mike "JMS786" wrote: I need to create a formula for end use as labels. The info in the first cell is ABC1107J100 and then I need it to increase by one in each cell after A1, i.e. 100, 101, 102, 103, etc. I then need to print these in Word label format. Please help!!!!!!! Thanks, JMS786 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
