In Progress

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 [url removed, login to view]@[url removed, login to view] 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@[url removed, login to view] 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, bulk domain registration csv, csv bulk domain registration, bulk domain whois csv, write domain login script run excel macro, put csv domain php, domain formula, domain value formula, csv import formula, finding domain formula, vbscript create domain user accounts using excel, excel macros import csv date time, formula domain value

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

Project ID: #15681338

Awarded to:

vlayausa

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
(123 Reviews)
5.7

15 freelancers are bidding on average $15 for this job

schoudhary1553

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
(217 Reviews)
7.3
paris2785

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
(132 Reviews)
6.6
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Relevant Skills and Experience Data Entry, Data Processing, Excel, Software Architecture, Visual Basic Proposed Milestones More

$15 USD in 1 day
(33 Reviews)
4.9
SShtv

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. [url removed, login to view] More

$10 USD in 1 day
(25 Reviews)
4.8
wsnel

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
(1 Review)
2.8
itwonder1

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
(2 Reviews)
2.8
johser

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)
0.8
mdsameerr

Hi, I am new to freelancer. I have done considerable work with excel macro/vba. I have done my work with 100% accuracy and within time. I have more than 2 years of experience. I previously worked with cyient ltd where More

$10 USD in 1 day
(1 Review)
0.2
sarangamgas

I am good working

$15 USD in 1 day
(0 Reviews)
0.0
atifcomp

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)
0.0
fAnggreni

A proposal has not yet been provided

$15 USD in 2 days
(0 Reviews)
0.0
chieto90

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
adeilsonbrito

A proposal has not yet been provided

$20 USD in 4 days
(0 Reviews)
0.0
AutomationArun

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)
0.0