Adding text from another cell into a cell with a format like this...

[Excelerize]

Hi all, this is my first post and this site looks promising so here we go. I want to add a text from another cell into a cell with a format like this:
<a href="http://www.phonesranking.com//"></a>

What I want to do:
Cell A1 contain a text "Super Cool"
Cell B1 contain <a href="http://www.phonesranking.com//"></a>
I want B1 result as this <a href="http://www.phonesranking.com/Super Cool/">Super Cool</a>

I tried
=CONCATENATE("<a href="http://www.phonesranking.com/",A1,"/"> ",A1,"</a>")
but getting an error. Please help, thanks.

 

[Khalid NGO]

Hi,
Welcome to the forum Chandoo.org...

If i understood correctly, Try:
=CONCATENATE("<a href=http://www.phonesranking.com/",A1,"/> ","</a>")
or
="<a href=http://www.phonesranking.com/"&A1&"/> </a"

Please explain more, if you need something else.
Regards,

 

[Hui]

How about:
="<a href=" & CHAR(34) & "http://www.phonesranking.com/" & A1 &"/" & CHAR(34) & "> " & A1 & "</a>"

 

[Excelerize]

Thank you both for the fast response. The one that works is
="<a href=" & CHAR(34) & "http://www.phonesranking.com/" & A1 &"/" & CHAR(34) & "> " & A1 & "</a>"

I believe its due to & CHAR(34) &. My guess is it replaces the double quote.
Cheers folks!

 

[Hui]

I can never be bothered working out how to get a Quote inside a Quote using Quotes so I prefer Char(34) as it always work

 

[bobhc]

@Hui

Hui's 34

= "Maurice " & CHAR(34) & "Jhonson" & CHAR(34) & " Richard"

="Maurice "Jhonsons" Richard"

my feeble effort

=CONCATENATE("""Hi"""," you")

= "Hi" " you"


.