Incrementing amounts when text is used

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.
 
G

Gary''s Student

In A1 enter:

=HYPERLINK("mailto:" & ROW() & "(e-mail address removed)",ROW() & "(e-mail address removed)")
and copy down
 
B

blairake

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.
 
G

Gary''s Student

You don't need to put in the 1. The ROW() function will supply that if the
formula is in column A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incrementing values 2
How do I fill adjacent cells with incrementing numbers 2
Incrementing numbers in a column 1
Incrementing a cell based on another cell's value 0
Drag and Fill Increment??? 4
Formulas won't increment when dragging to adjacent cells? 3
Incrementing Mixed text & numbers 8
Incrementing Rows and Columns 1

Top