Shorten a Long URL

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Jan 1, 2003

• #2

Do you mean...

=HYPERLINK("http://216.92.17.166/board/","mrexcel")

where "mrexcel" is a shorter ref?

 

Upvote 0

J

justabc

Board Regular

Joined

Dec 6, 2002

Messages

86

• Jan 1, 2003

• #3

I mean taking any URL especially if over 255 characters and creating a new URL as a substitute for that long URL which still directs to same page

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Jan 1, 2003

• #4

On 2003-01-01 10:03, justabc wrote:
I mean taking any URL especially if over 255 characters and creating a new URL as a substitute for that long URL which still directs to same page

Click to expand...

In A2 enter...

http://216.92.17.166/board/

In B2 enter...

viewtopic.php?topic=34342&forum=2&2

In C2 enter...

justabc

In D2 enter...

=HYPERLINK(A2&B2,C2)

 

Upvote 0

J

justabc

Board Regular

Joined

Dec 6, 2002

Messages

86

• Jan 1, 2003

• #5

Seems to work except returns for #Value if characters are too many-tried to break up a long URL into A2 and B2 and it returns #Value;if few characters as in your example it worked fine.

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Jan 1, 2003

• #6

On 2003-01-01 10:44, justabc wrote:
Seems to work except returns for #Value if characters are too many-tried to break up a long URL into A2 and B2 and it returns #Value;if few characters as in your example it worked fine.

Click to expand...

We are facing here a limit in Excel. I wonder whether you can make use of the services of...

http://makeashorterlink.com/ ?

 

Upvote 0

D

Dag

New Member

Joined

Feb 13, 2011

Messages

44

• Feb 13, 2011

• #7

Aladin Akyurek said:

Do you mean...

=HYPERLINK("http://216.92.17.166/board/","mrexcel")

where "mrexcel" is a shorter ref?

Click to expand...

He he Exactly! The best and very simple.

 

Upvote 0

D

Dag

New Member

Joined

Feb 13, 2011

Messages

44

• Feb 13, 2011

• #8

1. How I can edit my post here (or delete)?

2. Solution as '=HYPERLINK("http://lala.lal.la.html","URL")' is not perfect: Excel (2007) when you convert sheet to PDF can not recognize that cell as web-link. Means:
Cell A1: "http://lala.lal.la.html"
PDF output: hyperlink "http://lala.lal.la.html"

Cell A2: =HYPERLINK("http://lala.lal.la.html","URL")
PDF output: common text "URL"

Any ideas? Weird enough of course...

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Feb 25, 2011

• #9

Why would you expect a pdf file to recognise an Excel function? You will need to convert your hyperlinks to normal ones.

 

Upvote 0

D

Dag

New Member

Joined

Feb 13, 2011

Messages

44

• Feb 25, 2011

• #10

Andrew Poulsom said:

Why would you expect a pdf file to recognise an Excel function? You will need to convert your hyperlinks to normal ones.

Click to expand...

I didn't expect anything. Where did u find that?

Simple, that is not perfect solution. If I convert my hyperlinks back to normal ones, what I'll get? U think that Adobe acrobat will show them better then Excel? Table cell is table cell in both programs and when u have tough hyperlink in the last table cell (last column) - u haven't any normal solution for acrobat. Excel function for excel and then convert to HTML only.

 

Upvote 0