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.

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.

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.

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.

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.