Excel Formula..could not change the text

Question

I am using this formula to make an hyperlink for the path that is in AN column

=IF(ISBLANK(AN5),"",HYPERLINK(AN5,"(resume)"))

each row (AN1,AN2,AN3....) will have different paths and I want hyperlinks at Am1,AM2,AM3 .....for those paths. This formula worked fine for the whole column and the hyperlinks are working fine.

But the only thing is I could not change the hyperlink text "resume" to a different name like "Work history"..

When I change the name in the formula it is applying to only one cell that I changed but not to the whole column.

Lance Roberts · Accepted Answer · 2011-03-09 22:29:07Z

0

You have to click on the bottom right corner of the cell, and drag the formula through the entire column (where the formula already is) and it will replace them all.

answered Mar 9, 2011 at 22:29

Lance Roberts

22.9k32 gold badges115 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Patrick Honorez Over a year ago

quicker than dragging: DOUBLE-CLICK the little black square at the bottom right of the cell you need to copy. It will fill like magic till the first blank row.

user397316 Over a year ago

ya..but it changes for the cells that already have the link but not for the new ones.

Lance Roberts Over a year ago

@user397316, you'll need to be clearer on what you mean by "new ones"

Harry · Accepted Answer · 2011-03-10 03:07:10Z

0

Is the worksheet in Manual calculation mode? DO you see the word "Calculate" in the lower left hand corner? Hit f9 to recalculate the worksheet.

answered Mar 10, 2011 at 3:07

Harry

2561 gold badge2 silver badges14 bronze badges

Collectives™ on Stack Overflow

Excel Formula..could not change the text

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related