Open

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

137 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
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
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
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
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
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
(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.3
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)
2.2
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
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
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
aboolsophia14

I really need a job to help my family, i am still a student but i can guarantee you that I am responsible enough to finish all the tasks.

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

Hello! I have a simple solution using REGEXEXTRACT function. All you need is to copy paste the function I provide to your spreadsheet.

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

Hi sir ,I have done projects like this before and i m experienced in it .i m confident that work can be completed in 2 days.

$15 USD in 3 days
(0 Reviews)
0.0
$15 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
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