| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incrementing amounts when text is used
Is there a way to have the cells increment a number if there is text in the
string. Lets say I put in cell A1, and I want to show in cell. Is there a formula that will increment the numbers? I know the fill handle won't do it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Incrementing amounts when text is used
In A1 enter:
=HYPERLINK("mailto:" & ROW() & ",ROW() & ") and copy down -- Gary''s Student - gsnu201001 "blairake" wrote: Is there a way to have the cells increment a number if there is text in the string. Lets say I put in cell A1, and I want to show in cell. Is there a formula that will increment the numbers? I know the fill handle won't do it. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Incrementing amounts when text is used
I typed in the formula as shown but it didn't work. I put a 1 between the
first set of parenthesis, and 100 between the second set. When I hit enter I goit the error saying there was a problem with the formula, but it didn't offer a fix. "Gary''s Student" wrote: In A1 enter: =HYPERLINK("mailto:" & ROW() & ",ROW() & ") and copy down -- Gary''s Student - gsnu201001 "blairake" wrote: Is there a way to have the cells increment a number if there is text in the string. Lets say I put in cell A1, and I want to show in cell. Is there a formula that will increment the numbers? I know the fill handle won't do it. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Incrementing amounts when text is used
You don't need to put in the 1. The ROW() function will supply that if the
formula is in column A -- Gary''s Student - gsnu201001 "blairake" wrote: I typed in the formula as shown but it didn't work. I put a 1 between the first set of parenthesis, and 100 between the second set. When I hit enter I goit the error saying there was a problem with the formula, but it didn't offer a fix. "Gary''s Student" wrote: In A1 enter: =HYPERLINK("mailto:" & ROW() & ",ROW() & ") and copy down -- Gary''s Student - gsnu201001 "blairake" wrote: Is there a way to have the cells increment a number if there is text in the string. Lets say I put in cell A1, and I want to show in cell. Is there a formula that will increment the numbers? I know the fill handle won't do it. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Incrementing amounts when text is used
Got it, and it works great. Thanks for your help.
"Gary''s Student" wrote: You don't need to put in the 1. The ROW() function will supply that if the formula is in column A -- Gary''s Student - gsnu201001 "blairake" wrote: I typed in the formula as shown but it didn't work. I put a 1 between the first set of parenthesis, and 100 between the second set. When I hit enter I goit the error saying there was a problem with the formula, but it didn't offer a fix. "Gary''s Student" wrote: In A1 enter: =HYPERLINK("mailto:" & ROW() & ",ROW() & ") and copy down -- Gary''s Student - gsnu201001 "blairake" wrote: Is there a way to have the cells increment a number if there is text in the string. Lets say I put in cell A1, and I want to show in cell. Is there a formula that will increment the numbers? I know the fill handle won't do it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please do you know how to convert amounts to text in excel | Excel Discussion (Misc queries) | |||
| pasting large amounts of text | Excel Discussion (Misc queries) | |||
| Formula for Incrementing text & numbers | Excel Discussion (Misc queries) | |||
| Incrementing Mixed text & numbers | Excel Discussion (Misc queries) | |||
| How can I print a cell that contains large amounts of text? | Excel Discussion (Misc queries) | |||
Hybrid Mode
