HYPERLINK function Issue

[ray_b]

Hi All;

Has anyone any idea why the HYPERLINK function isn't working for me? It always returns a #VALUE! no matter I use the HYPERLINK function, CONCATENATE function with HYPERLINK or the use of the '&' to concatenate.

=HYPERLINK(B1&B2&B3&B4&B5,Link)

I should get a new link every time I change cell B2 and B4.

Thanks

Link part 1: Stockwatch
Link part 2: AAPL
Link part 3: &region=
Link part 4: U
Link part 5: &d1=20190819&d2=20191218&per=d&npdivs=20&width=830&priceheight=400&ptype=candle&indheight=100&log=F&ind1=none&ind2=none&ind3=vol&ind1p1=12&ind1p2=26&ind1p3=9&ind2p1=12&ind2p2=25&ind2p3=50&ind3p1=12&ind3p2=25&ind3p3=50&pov1=mae&pov2=mae&pov3=mas&pov1p1=50&pov1p2=&pov2p1=8&pov2p2=&pov3p1=20&pov3p2=&newsInd=T

 

[QuietRiot]

There's a limit using HYPERLINK to only 255 characters. Might need a VBA function instead.

 

[ray_b]

Damnnn looks like you're right QuietRiot..... I tried the function with a very short link and it worked just fine.

Thanks