CSV formula/macros

I have several excel spreadsheets that have different column formats. However they all have an email column with email addresses. Next to the email column there is an email format column.

I would like a script that would read from the email column and then add in the email format column a string of characters that will explain how the email is construed.

For example if the email says [login to view URL]@[login to view URL] then the email format column will show _F_._L_@_D_

_F_ being FIRST NAME

_L_ being LAST NAME

_D_ being domain

some email addresses have other formats. For example it could be bmarkey@xyz so the email format will be _FF__L_@_D_

_FF_ being first letter of the first name

_FL_ first letter of the last name

sometimes it can also be just _F_@_D_ or _L_@_D_

Also the separators between names can be a . (dot) but also an _ (underscore) like in bob_markey@[login to view URL] which becomes _F___L_@_D_

I would like the end result to be a formula or anything that I can simply plug into all my different CSV sheets.

MAX BID: $10

Skills: Data Entry, Data Processing, Excel, Software Architecture, Visual Basic

See more: design of macros and programming in vba with excel 2016 ebay, csv formula java, java csv formula, csv injection hackerone, formula injection vulnerability, csv injection calc, formula injection owasp, csv injection vulnerability, csv injection owasp, csv injection cheat sheet, csv injection tutorial, data entry, data processing, software architecture, excel, visual basic, visual basic for apps, microsoft excel, bulk domain registration csv, csv bulk domain registration

About the Employer:
( 456 reviews ) Richmond Hill, Canada

Project ID: #15681338

Awarded to:


Hello, I can do this for you, pretty quick. I am okay with your price of $10. Relevant Skills and Experience I am proficient with Excel and VBA and can finish this 100% accurate. Proposed Milestones $30 USD More

$15 USD in 1 day
(144 Reviews)

13 freelancers are bidding on average $16 for this job


Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with exce More

$40 USD in 1 day
(306 Reviews)

Hi there. I am Paris and I can develop this simple macro for you. Relevant Skills and Experience I've developed similar projects in the past. Proposed Milestones $10 USD - Deliver the final macro

$10 USD in 0 days
(170 Reviews)

Your task is clear to me and I am ready to execute the project for 10 USD for 1 day. Relevant Skills and Experience This is a screenshot of one of my works. [login to view URL] More

$10 USD in 1 day
(61 Reviews)

Hi, I can do this work. Individual and hard working person done your work accurately. Waiting your response. Relevant Skills and Experience Data Entry, Data Processing, Excel, Software Architecture, Visual Basic P More

$15 USD in 1 day
(19 Reviews)

I work with Excel formulae daily. I'll be able to deliver a crisp formula that works for every type of email address in your csv files! I hope to hear from you

$15 USD in 1 day
(4 Reviews)

Hello . I can help you to decide your task Relevant Skills and Experience Excel, VBA Proposed Milestones $10 USD - data formatting

$10 USD in 1 day
(1 Review)

I am good working

$15 USD in 1 day
(0 Reviews)

I understand your requirement, I can create a macro to deal with this and a compact algorithm to deal with email scenarios you get. Macro will have alot of flexibility at your end to change if you wish to.

$10 USD in 2 days
(0 Reviews)

A proposal has not yet been provided

$15 USD in 2 days
(0 Reviews)

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)

A proposal has not yet been provided

$20 USD in 4 days
(0 Reviews)

The completed excel will fill the required coulmn with computed data as per requirement on click of a button located on same sheet. Relevant Skills and Experience Have worked on excel macros extensively and have very More

$15 USD in 1 day
(0 Reviews)