UC2 Community Board
This group and forum is for everyone to communicate with each other and build a community around... View more
Organizer:
- Organized by
-
-
Reply To: Excel hyperlink
-
Points: 8,900Rank: UC2 Brainery Purple Belt III
Definitely shortens it:
=IFERROR(HYPERLINK(A1,TEXTBEFORE(RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”\”,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””))))),” – “)),””)