Closed

excel cleanup

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, PHP, Visual Basic

See more: xsformatcleaner, clean excess cell formatting on a worksheet excel 2010, excel cleanup tool, excel excess formatting cleaner add-in 2010, too many cell formats excel 2010, excel 2016 high memory usage, clean excess cell formatting excel 2016, excel 2013 high memory usage, freelancer excel below $10, for excel do i need business or home, i have 500 pdf to be transcribed in excel in 10 different fields need it quick, i have 500 pdf to be transcribed in excel in 10 different fields need it quick!, excel 2007 i want all my workbooks customized, excel macro open multiple spreadsheets, excel macro create multiple spreadsheets

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

Project ID: #15675120

36 freelancers are bidding on average $22 for this job

schoudhary1553

Greetings, I can help you in excel cleanup. Please ping me for more discussion. Please see my profile i have deliver almost 270 projects with 100% client satisfaction. Relevant Skills and Experience I have more th More

$50 USD in 1 day
(254 Reviews)
7.5
$10 USD in 0 days
(58 Reviews)
5.9
$25 USD in 1 day
(46 Reviews)
5.5
abhi98041

i can do it for you.

$10 USD in 1 day
(72 Reviews)
5.0
sadif18

Sir, I am willing to do your project and ready to start work. I will provide you a good result with accuracy. My aim is to satisfy my client by my work. Please response. Thanks Relevant Skills and Experience Data Ent More

$10 USD in 1 day
(96 Reviews)
5.0
rajafaizan

Hi, I'm Dynamic Professional has good command on Office tools like (Excel, Word, PowerPoint, Access). I will done it as per your requirement. Let's chat for further process. Thank You Relevant Skills and Experience More

$25 USD in 1 day
(34 Reviews)
4.6
meeshal1994

Hello, If you really want this then contact me, I have done it before. Thanks Meeshal k Relevant Skills and Experience Have formulated many things using PHP and JAVA Proposed Milestones $100 USD - a formula

$100 USD in 3 days
(26 Reviews)
5.0
mtdevil369

Dear, HERE Ready to start NOW !!! I have read the details and lot of experience personal email addresses and different types of projects. I am waiting for your quick positive reply Relevant Skills and Experience Data More

$25 USD in 0 days
(16 Reviews)
3.8
JackieXu

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard. Relevant Skills an More

$25 USD in 1 day
(19 Reviews)
4.3
yh2013

I worked with many projects based on Excel and macros. Relevant Skills and Experience My skills are in Excel with macros, also Python, C#. My experience is 3 yrs. Proposed Milestones $25 USD - complete the whole proj More

$25 USD in 1 day
(18 Reviews)
4.1
Carlosemadrizmor

I can do it fast. I use VBA, and MsAccess. for this work. I can give product in escel, vsv, database, anything else. Relevant Skills and Experience +10 years Excel, +10 years sofware developer, database ans SQL admini More

$15 USD in 1 day
(3 Reviews)
3.1
SoufianeAch

Use excel formula to analyze how an email address is construed Relevant Skills and Experience Hi! I use excel daily during my internship and have accomplished many project of process automation using excel. I'm rigoro More

$10 USD in 1 day
(6 Reviews)
2.7
$13 USD in 0 days
(7 Reviews)
2.2
XcelSolution

I have been working every day with Excel: formulas, databases, reports, and VBA for the past 10 years. Relevant Skills and Experience Excel: formulas, databases, reports, and VBA Proposed Milestones $10 USD - Excel f More

$10 USD in 1 day
(2 Reviews)
0.8
gajrajsinghs

A proposal has not yet been provided

$15 USD in 5 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
imamsholihuddin

I already familiar with Net technology and php excel. Just give me the detail of Excell that you want to program and I will make the script for you. You can try me for free and take if satisfied Relevant Skills and Ex More

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

A Relevant Skills and Experience a Proposed Milestones $25 USD - A

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

Good day, I noticed your post project, I am interested with this project. I am Bachelor in Office System Management, I have experience in doing excel work. I have a question regarding the project:- 1. What is t More

$25 USD in 5 days
(0 Reviews)
0.0