Function to concatenate with friendly URL

[mi1stormilst]

I am trying to combine two fields into a hyperlink with a friendly URL, but since the Concatonate function wants to add the text to the URL it breaks the hyperlink, perhaps there is a better way?

B
http://www.google.com
/advanced_search?hl=en
=CONCATENATE(B1, B2)
=HYPERLINK(CONCATENATE("CASE NUMBER"," ", B3))
=HYPERLINK(CONCATENATE( B3))


CASE NUMBER - This text has an embedded hyperlink to http://www.gooogle.com
/advanced_search?hl=en
=HYPERLINK(CONCATENATE(B8, B3))

If the URL is displayed without the text this function works, how can I display "CASE NUMBER in the field with the hyperlink )-:

 

[mi1stormilst]

----------------------------------------------------

I think I got it, was just syntax error )-:

=HYPERLINK((CONCATENATE(B1, B2)), "CASE NUMBER")

----------------------------------------------------

I am trying to combine two fields into a hyperlink with a friendly URL, but since the Concatonate function wants to add the text to the URL it breaks the hyperlink, perhaps there is a better way?

B
http://www.google.com
/advanced_search?hl=en
=CONCATENATE(B1, B2)
=HYPERLINK(CONCATENATE("CASE NUMBER"," ", B3))
=HYPERLINK(CONCATENATE( B3))


CASE NUMBER - This text has an embedded hyperlink to http://www.gooogle.com
/advanced_search?hl=en
=HYPERLINK(CONCATENATE(B8, B3))

If the URL is displayed without the text this function works, how can I display "CASE NUMBER in the field with the hyperlink )-: