Rename hyperlik in Excel

I have done a data scrape of data and pulled some hyperlink from a website into excel. It extracted all the information I need by the URL exceeds 225 characters so when I comes into excel it is converted to text and not a clickable link. I found that if I take it to word and edit the hyperlink and make the Text to Display something else my link work…

Anyone know how to automate this process?

You can try inserting like this using like a write cell activity:
=HYPERLINK("http://mysuperlong.url.com", "My Small Text")

2 Likes

where would I put this activity?

@uidonna.jones
have also a look on these activities from the components published by @balupad14

grafik

And

grafik

1 Like

I had never tried this… I have downloaded the package but How do i know which one is the Hyperlinks add?

1 Like

does this work in Studio Pro or Studio X

1 Like

@balupad14 will for sure help us. Lets wait for him

2 Likes

Thank you @ppr.

in this case , you can use remove hyperlink and add hyperlink activity.

Check this video…

Thank you
Balamurugan.S

Yes. It will work in studio pro and studio x.

Thank you
Balamurugan.s

First thing you have to understand is that you can not use your data scrape activity if the results of it will break your excel, unless you are willing to work on your DataTable before writing it back to excel, if so, tell us the exact content of the column that contains the link that became too big and we help you change it to what i showed you before (would be like this in a for each row):
row("my link column")="=HYPERLINK(row("my link column").ToString, """My Small Text""")"

Thanks…the data scrape pulled the data i needed correctly, I have attached the spreadsheet…I worked with an excel help line to add the "http://… " because when I scraped the data that was not part of the address.

I needed to make the scrape data a hyperlink but when I added the https://www.linkedin.com// it made the web address too long and converted it to text instead of a hyperlink.

I want to use your solution in a for each row, but not sure where this action should be done…

This is the original data scrape
LINKED IN PROFILE
/recruiter/profile/682405291,78gg,CAP?searchController=smartSearch&searchId=4223813586&total=1782&searchCacheKey=c627e55e-ea87-46c3-963e-c1838a2bcb67%2CbJK4&searchRequestId=1de42dbd-0371-49da-92d1-c27f952ea96b%2Cj0xm&searchSessionId=4223813586&origin=PAGE&memberAuth=682405291%2C78gg%2CCAP
/recruiter/profile/438560950,Z7Q4,CAP?searchController=smartSearch&searchId=4223813586&pos=1&total=1782&searchCacheKey=c627e55e-ea87-46c3-963e-c1838a2bcb67%2CbJK4&searchRequestId=1de42dbd-0371-49da-92d1-c27f952ea96b%2Cj0xm&searchSessionId=4223813586&origin=PAGE&memberAuth=438560950%2CZ7Q4%2CCAP

this is the link with the HTTP… i needed added and creates this link (more than 255 characters)
https://www.linkedin.com//recruiter/profile/381880891,8UAN,CAP?searchController=smartSearch&searchId=4223813586&pos=4&total=1782&searchCacheKey=c627e55e-ea87-46c3-963e-c1838a2bcb67%2CbJK4&searchRequestId=1de42dbd-0371-49da-92d1-c27f952ea96b%2Cj0xm&searchSessionId=4223813586&origin=PAGE&memberAuth=381880891%2C8UAN%2CCAP

this makes it text in excel. So I want to use the hyperlink formula above to make a “Candidate Link” The work around I found is to take the link into Word and right click and edit the Text to display…but I have 1000 links I need to do.Linked in Profile Hyperlink2.xlsx (179.0 KB)

Why do I continue to get a runtime error when I try the Get hypelink action

1 Like

Hi @uidonna.jones,

Use the excel application scope from BalaReva Easy Excel…

Regards
Balamurugan.S

You just need an assign activity to edit the column where your link should go…