URL Linking

[ExcelJunior]

Hello,

I have searched through this forum extensively and have attempted various combinations of solutions to problems that are similar to mine, but not quite exactly. Although mentally exhausted I am not giving up quite yet.

My task is seemingly quite simple: Have part numbers in a spreadsheet link to their respective e-commerce URL

The part number is in the URL as seen in the following example: http://shop.website.com/product/partnumber

The part numbers are used repeatedly throughout the document.

My goal is to have part numbers link to the part number URL where displayed in the document without displaying the full URL. Seemingly simple but effectively stumping me.

I appreciate the ability to ask such a community of experts for guidance and education.

Thank you for taking the time to read and apply your knowledge to this.

Regards,
Son Of Mr. Excel
(Not really related to Mr. Excel)

 

[drsarao]

Welcome McExcel!
A possible solution:

Excel Workbook
	A	B	C
1	http://shop.website.com/product/partnumber	PartNoxyz	PartNoxyz
Sheet1

Excel 2003

Cell Formulas
Range	Formula
C1	=HYPERLINK(A1,B1)

 

[ExcelJunior]

Thank you Dr. Sarao, that is the conclusion I came up with as well, now to apply it to all instances of a part number. Apparently you can't do a find and replace containing formulas.