Completed

Regex expert familiar with google spreadsheets

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

Skills: Excel, Data Processing, Regular Expressions

See more: css expert familiar theme, email addresses google spreadsheets google contact list, seo expert work google, google maps expert contact google maps, count entry google spreadsheets, google spreadsheets api php, google spreadsheets timetime, mls checker google spreadsheets, saving form php google spreadsheets api, google spreadsheets imacros, magento seo expert page google, google spreadsheets php api add row, google spreadsheets seo, expert advertising google adwords needed, perl net google spreadsheets, expert advice google adsense, google spreadsheets perl, mashup google spreadsheets calendar, google spreadsheets help, google spreadsheets connects ecwid store

About the Employer:
( 86 reviews ) Dublin, Ireland

Project ID: #25489188

Awarded to:

ksriniravi

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

$10 USD in 1 day
(202 Reviews)
6.8

141 freelancers are bidding on average $16 for this job

cgullapalli

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

$30 USD in 1 day
(919 Reviews)
8.0
sergiuloghin

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!

$15 USD in 1 day
(304 Reviews)
7.8
mohsinalizafar

Hi sir i can help you in this please message me so that we can start i am waiting for response thanks

$20 USD in 7 days
(31 Reviews)
5.3
belalihabibullah

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

$10 USD in 1 day
(41 Reviews)
5.3
ARTICLEYOUWANT

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.

$10 USD in 2 days
(6 Reviews)
4.1
elbruninh

⭐⭐⭐Hi, i can do it, can you send me the data? i have 18+ years of experience with Regular Expressions let me know if you are interested [login to view URL]

$10 USD in 1 day
(20 Reviews)
4.4
mdrakibuddn

$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

$10 USD in 1 day
(5 Reviews)
3.2
ahmedala3sar1111

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

$10 USD in 1 day
(4 Reviews)
3.0
sathiswarrior

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

$10 USD in 1 day
(5 Reviews)
2.4
imtyzooel71n

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 USD in 1 day
(4 Reviews)
1.7
mohanasundarik24

"""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

$10 USD in 1 day
(5 Reviews)
1.9
zubairmbafinance

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

$20 USD in 2 days
(2 Reviews)
1.2
Pooja19jayswal

Hello, Sir I Am Pooja Jaiswal. and am interested to do your help . please share with me your data . thanks&Regards, Pooja

$20 USD in 7 days
(0 Reviews)
0.0
akkijais86

Dear sir/ma'am I would like to tell you I am expert in excel and data entry work . Plz allow me to do work on this project . Thanks Relevant Skills and Experience I am fluent in Microsoft Excel and data entry .

$25 USD in 1 day
(0 Reviews)
0.0
wwwmaklemza

I am very fast in typing and i can finish your project very fast and that can save you a lot of time

$20 USD in 7 days
(0 Reviews)
0.0
joysarkerprince

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

$25 USD in 1 day
(0 Reviews)
0.0
RAMESHB200

HERE IS YOUR ANSWER: 1. With the google-sheet open, use the FIND and REPLACE option (CONTROL H in windows). 2. Use Regex (?:.*?(\w[^@\s]*@[^@\s]{2,}).*?|.+) under the FIND field 3. use expression $1 in the REPLACE fiel More

$10 USD in 1 day
(0 Reviews)
0.0
chachu786

Since I have been using excel for the last 17 years and confident to do this work within the frame time.

$20 USD in 7 days
(0 Reviews)
0.0
shaliniojha30

hello I'm shalini . I want to do your work more accurately and on time ... 100 ℅ grantee for good work ....tq

$20 USD in 1 day
(0 Reviews)
0.0
Duanitika

I can make sheet with desired as many as large dataset is. I am good at advance excel as well as formulas if needed. Please let me do this project.

$25 USD in 1 day
(0 Reviews)
0.0