Regex expert familiar with google spreadsheets
$10-30 USD
Paid on delivery
Hi,
I have a list of rows containing names and email addresses.
I need to get rid of names and keep email addresses only.
I want to do it in spreadsheets with bulk replacing everything not containing @ in it with an empty field (nothing).
Example below (please note that Freelancer does not allow me to put email address into project description so I replaced @ with *):
Peter Jackson
john*[login to view URL]
John Wayne
Peter Andres
valeria232*[login to view URL]
michael*[login to view URL]
I would enter regular expression provided by you into the replace field and as a result my text would look like this (desired state with emails only, as all string without @ in it were replace by empty field):
john*[login to view URL]
valeria232*[login to view URL]
michael*[login to view URL]
As this is very simple task, budget is 10 USD
Thanks
Project ID: #25489188
About the project
Awarded to:
Greetings! Actually the more easier option is to use filters as opposed to Regex. Set up a filter with Filter by condition option. Choose Text does not contain option and enter @. All values without text @ would be More
133 freelancers are bidding on average $16 for this job
HI, I am good at Google sheet formulas. I can pull the information you are looking for using formulas. Looking forward to work on the project. The formula is flexible for any number or rows in google sheet. I will wr More
Hello! I can resolve this now with a VBA script. Can you award me? You will not be dissapointed, I have a big 30% rehire rate. Thank you!
Greetings, I can do this project with $10 I can do this project with $10 I can do this project with $10 I can do this project with $10 If you think me best candidate for the project then move on for next process. T More
$10 I agree Hi There! https://docs.google.com/spreadsheets/d/1BNsw-KqW3GU6smzNgA-6q2Fo5VIM71OyvZRQgq-6pdU/edit#gid=0 I am ready to start the job for you. Do you need quick samples from me before hiring? Please let More
Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task.I am a quick, reliable and efficient worke More
Hi sir i can help you in this please message me so that we can start i am waiting for response thanks
I am ready to do this task at USD 10 with quick turnaround time. I am ready to do this task at USD 10 with quick turnaround time.
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I understand t More
Hi sir , I am Ahmed ,I wish you a good day . I have done many projects on MS office programs (word, excel, PowerPoint, Prezi, pdf, ...etc.) for five years. I have done similar project before you can check it in my po More
Hi sir, I am Zubair I have done MBA in finance I read your project and I have experience of more than 4 years I have worked for MTBC an American company as billing executive with the experience and paid tools I have I More
Hi, I understand your proposal and I'll complete the task within one hour. Please share the file ready to start. Thanskwtih regards Sathiya N
Hi Sir, I read your description If you choose me, I complete your work quickly & perfectly. Your work is nice and workable for me. You are welcome to see my Profile & Client Feedback. I have 4 years experience in More
dear sir plz give me this work i ill best to try ghis work and i ill do this work just time and i think your mony will be safe so plz give me this work i also a frofosonal worker in this project so plz u think me that More
I am interested in completing your task as I have had a few experiences working with excel and data processing and I can assure you that I will do this work with complete accuracy. I look forward to work with you.
I will complete it seriously. I will do it within the given time and honestly i will make sure that there is any any error.
Expert in Google sheets, can deliver even in hours. Can provide output with formulae and other methods if needed.
Hi Sir. I'm interested with your work project and I would love to complete this task. I am expert in using Microsoft tools so I have many experience in using spreadsheet. So, I really hope that you would give me a chan More
Sir/Madam Please give me a chance to prove myself, I have 3 year experience on this type of work so please give me chance sir. thanks