turning multiple links into hyperlinks

[nmss18]

Simple question. (I once knew this and just cant remember now).

I have a column with this type of STATIC data:

http://workorder/incidentReport.aspx?incident=3-4093
http://workorder/incidentReport.aspx?incident=3-4094
http://workorder/incidentReport.aspx?incident=3-4095
http://workorder/incidentReport.aspx?incident=3-4096
http://workorder/incidentReport.aspx?incident=3-4097
http://workorder/incidentReport.aspx?incident=3-4098
http://workorder/incidentReport.aspx?incident=3-4099
http://workorder/incidentReport.aspx?incident=3-4100
http://workorder/incidentReport.aspx?incident=3-4101

How can I turn them all into hyperlinks?

Thanks in advance.
Nathan <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[Gary McMaster]

Is it the "Hyperlink" function you're after?

Gary

Excel Workbook
	A	B
1	http://workorder/incidentReport.aspx?incident=3-4093	incident=3-4093
2	http://workorder/incidentReport.aspx?incident=3-4094	incident=3-4094
3	http://workorder/incidentReport.aspx?incident=3-4095	incident=3-4095
4	http://workorder/incidentReport.aspx?incident=3-4096	incident=3-4096
5	http://workorder/incidentReport.aspx?incident=3-4097	incident=3-4097
6	http://workorder/incidentReport.aspx?incident=3-4098	incident=3-4098
7	http://workorder/incidentReport.aspx?incident=3-4099	incident=3-4099
8	http://workorder/incidentReport.aspx?incident=3-4100	incident=3-4100
9	http://workorder/incidentReport.aspx?incident=3-4101	incident=3-4101
Sheet1

 

[nmss18]

Wow, i never knew about that function. it worked! thanks much!