Closed

Excel script/macro

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: script macro excel 2007, excel script macro, script macro excel, macro excel script, excel 2007 script macro button, excel 2003 macro script, write script macro copy data website excel, excel script macro export xml, script create excel 2007 macro, fun macro excel script, script excel spreadsheet macro read cells, excel script copy paste cells macro, script macro excel 2003, convert excel 2000 macro excel 2007 macro, excel 2000 macro web

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

Project ID: #15675467

48 freelancers are bidding on average $22 for this job

schoudhary1553

Greeting, I have understood your Excel script/macro task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Data E More

$60 USD in 1 day
(220 Reviews)
7.3
paris2785

Hi there. I am Paris. I suggest developing a macro that will handle the mail addresses and rewrite them in the formats you mention. The macro will be initiated by clicking a single button. Relevant Skills and Experien More

$10 USD in 0 days
(132 Reviews)
6.6
sunsoftpro

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project.  I'm ready to discuss and do hard working so that complete great job. Can you discuss requirem More

$26 USD in 44 days
(15 Reviews)
4.9
mpunn2007

. Relevant Skills and Experience . Proposed Milestones $15 USD - ms .

$15 USD in 1 day
(9 Reviews)
3.1
ikramulislam

Hello Sir, I read your task requirement and sure I can deliver your project with 100% quality. I expert Data Entry, Excel, Internet Research, Research, Web Search. Thank you Ikramul Islam. Relevant Skills and Experi More

$20 USD in 1 day
(2 Reviews)
0.6
Tylamafani

I do data entry,data cleaning,data searching and statistical data analysis using SAS, Excel, R, SQL, Excel VBA, SPSS, NCSS, STATA and other statistical software tools Relevant Skills and Experience I do data entry,da More

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

A proposal has not yet been provided

$10 USD in 3 days
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
thengadayil

Excel spread sheet column format tobe converted to email ids Relevant Skills and Experience Speed in typing and understanding the job nature Proposed Milestones $25 USD - Understanding the data given and in the sprea More

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

A proposal has not yet been provided

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

A proposal has not yet been provided

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

A proposal has not yet been provided

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

Dear Sir I think it's not a difficult task, if I can obtain a little more samples, I can work out it by formula or VBA. Best regards

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

i am interested on this job Relevant Skills and Experience Summarise your bid for this project in your own words Proposed Milestones $25 USD - milestones Propose a list of key tasks and deliverables as a series of m More

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

Having extensive knowledge on VBA. We can achieve this. Kindly provide all the possible combinations and the logic to identify first name n last name. Is both first name n last name mandatory ?? Relevant Skills and More

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

Hi, I am very interested with your job Relevant Skills and Experience Writing and typing expert Proposed Milestones $25 USD - Complete job

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

A proposal has not yet been provided

$22 USD in 1 day
(0 Reviews)
0.0
sidharthsarkar

A proposal has not yet been provided

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

Excel formulas and macros are part of my day to day job Relevant Skills and Experience I've built reports, databases, and complex data analysis using excel

$30 USD in 1 day
(0 Reviews)
0.0
kevin1591

i make this job with a macro in excel Habilidades y experiencia relevante Visual Basic applied to excel Htos propuestos $15 USD - elaboration of algorithm

$15 USD in 1 day
(0 Reviews)
0.0