Create an EXCEL function that removes the hyperlink and leaves the url

$10-30 USD

Completed

Posted

over 3 years ago

$10-30 USD

Paid on delivery

I need an Excel function that removes the hyperlink information and only leaves the url. I have =HYPERLINK("[login to view URL]","Edit Submission") and I want [login to view URL] in a new column I have read [login to view URL] but don't have time to get it to work. The file is attacted.

Excel

Project ID: 28984712

About the project

12 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@mdrakibuddn

Hi there, I checked your attached excel file. I can remove HYPERLINK link and I will keep just the URL of the new column. I can complete this 90 rows within few time. Best Rakib

$10 USD in 1 day

5.0

(62 reviews)

5.5

12 freelancers are bidding on average $16 USD for this job

@Venkat2011sri

Hello, This is Venkat. With in 5 minutes i will complete it. Please ping a message. I have 10 years of Experience in Data Entry, Web Scraping, PDF to Excel and other tasks. I look forward to work with you. I will give full refund if you are not satisfied with the quality of work. I am ready to provide sample. Thanks

$10 USD in 1 day

5.0

(182 reviews)

7.3

@MimiFL

Hi, i can write a simple macro that will extract this for you, if you are interested in working with me, feel free to message me and i will help you immediately.

$15 USD in 1 day

5.0

(584 reviews)

7.2

@AnowarRatul

-------------EXCEL EXPERT I CAN START RIGHT AWAY--------100% ACCURACY Hello there I have check description and attachment I can remove HYPERLINK and create function as your requirements do this work please knock me I am waiting your response Thanks Anowar

$10 USD in 1 day

5.0

(238 reviews)

6.2

@hdlan

Hi, I can give you VBA formula that extracts URL from hyperlinked text. Let’s discuss if you’re interested. Best regards, Duong

$15 USD in 1 day

4.9

(51 reviews)

6.5

@sevillajk01

Hello, let me do it for you. I am available now and can start immediately. Feel free to message me anytime. Thank you

$20 USD in 1 day

4.9

(55 reviews)

5.2

@irfaanmeah

Hey there, I can write a formula to achieve this in excel. Please let me know if you would like to discuss the project on a call or have a chat. Thanks, Md Irfaan Meah

$30 USD in 1 day

5.0

(20 reviews)

4.8

@anashaat95

I can extract the urls in the excel file within 10 mins with 100% accuracy. Please, chat with me. Thanks.

$10 USD in 1 day

5.0

(8 reviews)

3.9

@hashimblockchain

Hi there,! I am Hashim Ali I'm professional in kind of PDF conversation and data entry job and valuable experience. I performers data entry related tasks like copy-paste, data collection, web scraping, etc. I’m comfortable working with individuals and businesses. Please see a few of my offered services below: · PDF CONVERSATION · PDF TO WORD · PDF TO EXCEL · WORD TO PDF · COPY PASTE · DATA ENTRY · DATA COLLECTING · DATA RESEARCH

$20 USD in 7 days