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

$10-30 USD

Complété

Publié

il y a plus de 3 ans

$10-30 USD

Payé lors de la livraison

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

N° de projet : 28984712

Concernant le projet

12 propositions

Projet à distance

Actif à il y a 3 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@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 en 1 jour

5,0

(62 commentaires)

5,5

12 freelances proposent en moyenne $16 USD pour ce travail

@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 en 1 jour

5,0

(182 commentaires)

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 en 1 jour

5,0

(584 commentaires)

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 en 1 jour

5,0

(238 commentaires)

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 en 1 jour

4,9

(51 commentaires)

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 en 1 jour

4,9

(55 commentaires)

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 en 1 jour

5,0

(20 commentaires)

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 en 1 jour

5,0

(8 commentaires)

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 en 7 jours