CODEWITHSUNDEEP
excelhyperlink
r.r
r.r

Reputation: 7153

insert hyperlink for more that 1000 entries in excel

i habe many entries in excell ( more than 3000 ). actually their are hyperlink but just like a text. i need to convert them in excel hyperlink but dont know how do to that with thousends of entries. please help.

\\192.162.0.2\public
\\192.162.0.2\public\Big-PC.log
\\192.162.0.2\public\InstantReview-ExperimentalHive.reg
\\192.162.0.2\public\InstantReview.reg
\\192.168.0.2\public\Invitation-BLUB.ir

Upvotes: 0

Views: 1670

Answers (2)

bpgergo
bpgergo

Reputation: 16037

I'll give you a generic answer to these sorts of problems.

  1. start Macro recording
  2. convert the first item (convert your fisrt text cell to hyperlink)
  3. stop Macro recording
  4. open the recorded macro and copy the code snippet that does the job
  5. write a function (using the code snippet) that iterates over all your items and does the job

(If you have further problems with one specific step, then that should be considered as a new question, I guess)

Upvotes: 0

Alex K.
Alex K.

Reputation: 175826

Just use the formula & drag;

=HYPERLINK(A1, A1)

Edit;

I put =HYPERLINK(B3, B3) in the formula bar and hit enter (to get the colour effects that don't seem to appear otherwise for some reason) then dragged down;

enter image description here

Upvotes: 2

Related Questions