Excel Question - might be sorted!

[courtg9000]

Think I might have sorted it

I have 2 columns of data
Collum A contains a text string and column B contains a hyperlink (eg https://anylink.com)
I want to return a column with the title and the hyperlink embedded so that the data can be dumped onto a raw html page
the returned value in each cell should be something like this: my value and embedded fancy link (don't bother clicking the link it only goes to the homepage for these forums)
Does the learned panel have any suggestions please?

[Bodger]

In case you haven't sorted this one:

My HTML is rusty, but the format for this is something like:

Your Title is Here <a href="yourlinkishere.com">

So you can create column c something like this

="<a href ="""&B1&""">"&A1&"</a>"

<a href="url">link text</a>

Note the additional quotation marks to escape the quoatation marks inside the HTML

Link to Google

www.google.com

<a href="www.google.com">Link to Google</a>

[courtg9000]

In case you haven't sorted this one:

My HTML is rusty, but the format for this is something like:

Your Title is Here

So you can create column c something like this

=""&A1&""

link text

Note the additional quotation marks to escape the quoatation marks inside the HTML

Link to Google

www.google.com

Link to Google

Thank you