How to add hyperlinks to mass amount of data without having your cell be a formula.

scottwiebe

New Member
Joined
Nov 9, 2018
Messages
6
This may sound confusing and I will try to clear up what I am trying to do here.
I think it's awesome that you can create hyperlinks to a mass amount of data by using the =HYPERLINK formula. The problem is, I want my end data to be the friendly text with a hyperlink attached to it. I don't want that data to be a formula, because then you have to have 2 columns with identical data (not actually identical, but it appears so because of the friendly name). Is there a way to actually attribute the hyperlinks to the formula cells so that I could copy and paste the formula column as values and then the hyperlinks would still be attached? Then I could also delete the first column. See my excel sample below.

Book2
AB
1EPB1031MFEPB1031MF
2EPB10U1LEPB10U1L
3EPB1131MFEPB1131MF
4EPB1131PMFEPB1131PMF
Sheet1
Cell Formulas
RangeFormula
B1:B4B1=HYPERLINK("ebms:inventry?EPB1031MF", A1)
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Sufiyan97

Well-known Member
Joined
Apr 12, 2019
Messages
810
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
You can give Hyperlink without using formula Just Type Ctrl+K in a cell where you want to give the hyperlink and then type your url there.

1633023338044.png
 

scottwiebe

New Member
Joined
Nov 9, 2018
Messages
6
You can give Hyperlink without using formula Just Type Ctrl+K in a cell where you want to give the hyperlink and then type your url there.

View attachment 48084
Yes, but then I have to type the different hyperlink for each item. My hyperlink has a string of text that always stays the same, "ebms:inventry?", followed by the text in column A. I want to use a formula to add a hyperlink to the original cell and then be able to delete the formula column. I don't really know how all this works, but it may have to be done by a macro.
 

Forum statistics

Threads
1,175,486
Messages
5,897,689
Members
434,673
Latest member
kktfc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top