Incrementing amounts when text is used

  • Thread starter Thread starter blairake
  • Start date Start date
B

blairake

Is there a way to have the cells increment a number if there is text in the
string. Lets say I put (e-mail address removed) in cell A1, and I want to show
(e-mail address removed) in cell. Is there a formula that will increment the numbers?
I know the fill handle won't do it.
 
In A1 enter:

=HYPERLINK("mailto:" & ROW() & "(e-mail address removed)",ROW() & "(e-mail address removed)")
and copy down
 
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.
 
You don't need to put in the 1. The ROW() function will supply that if the
formula is in column A
 
Back
Top