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

[scottwiebe]

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
	A	B
1	EPB1031MF	EPB1031MF
2	EPB10U1L	EPB10U1L
3	EPB1131MF	EPB1131MF
4	EPB1131PMF	EPB1131PMF
Sheet1

Cell Formulas
Range	Formula
B1:B4	B1	=HYPERLINK("ebms:inventry?EPB1031MF", A1)

 

[scottwiebe]

Sorry, I had a mistake in my mini sheet formulas. Here is the fixed version.

EPB Price Changes.xlsx
	A	B
1	EPB1031MF	EPB1031MF
2	EPB10U1L	EPB10U1L
3	EPB1131MF	EPB1131MF
4	EPB1131PMF	EPB1131PMF
Sheet1

Cell Formulas
Range	Formula
B1:B4	B1	=HYPERLINK("ebms:inventry?"&A1, A1)

 

[Sufiyan97]

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.

 

[scottwiebe]

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.