Parsing text out of a string

[ShSimps]

I have the above issue which I am sure is a simple fix but I am far from a power user. I receive a list of companies with their link all in one text file. I got that into column B quite easily and then you can see the formula I used to split it into the text and the link of the company. What I have been trying to do is get that link so it is clickable but it is just a formula. I've tried copying the results to another cell but it is not giving me what I would like. Any suggestions. I don't mind if I have to hide a column or two to get the end result I want.

 

[Trebor76]

Hi ShSimps,

Welcome to MrExcel!!

You can use the HYPERLINK function like so:

=HYPERLINK(MID(B6,SEARCH("http",B6),255))

You can also give the link a friendly name.

HTH

Robert