How do I do a hyperlink that exceeds 255 characters?

[Galena1]

Say I want to create a proxy hyperlink like this:

=HYPERLINK("http://www.google.com/search?q="&B3&"&safe=active","Search Google")

but the URL address I'm going to use is way too big for the cell (I think max is 255 characters).

How do I do that?

Thanls!

 

[crane003]

Best workaround: create your URL without the HYPERLINK formula ignoring the 255 character limit. Excel allows you to "assign" a URL to a cell (of any length) by right clicking --> Link. You can reference any cell in the sheet for that URL. The ONLY trick is it can't read the formula so you need to copy and paste values of the formula to the cell you want to reference. You can record a very simple macro to copy and paste values of the cell you want to refence for the URL, assign the URL, then delete the pasted values. The ONLY OTHER trick is that rudimentary recorded macros also have the same 255 character limit. So you use this formula =LEFT(A1,199) and this formula =MID(A1,200,LEN(A1)) to split it up when copying and pasting your reference URLs.

 

[RaviWildcat]

(Answering an 8 year old question for anyone who hits this page like i did)

Create the Hyperlink in Microsoft Word and copy paste into Excel.

Word 2013 allowed to create a long (>255 character) Hyperlink as mentioned in below steps ;
pasting that hyperlink from Word to Excel didn't truncate the link address and the technique worked for me.

1. Put the address in Word, say :

http://www.mrexcel.com/verylonghyperlink

2. Give a space right next to last character of the hyperlink address and word would convert it to a clickable hyperlink.

3. Right click that hyperlink and select "Edit Hyperlink".

4. In "Text to display:" field give the text intended to be visible. Click "Ok".

5. Cut/copy this hyperlink and paste it into the Excel cell. Done

Not sure why this works but it works!

Alternatively, you can simply click "insert hyperlink" and paste it in (I've been playing around with concatenating 2 strings for the last 2 hours when I found your solution - sometimes the easiest solution is the best one!