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:
( 434 reviews ) Richmond Hill, Canada

Project ID: #15675120

41 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
(229 Reviews)
7.3
$10 USD in 0 days
(45 Reviews)
5.7
$25 USD in 1 day
(43 Reviews)
5.4
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
(95 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
(24 Reviews)
4.9
abhi98041

i can do it for you.

$10 USD in 1 day
(36 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
(17 Reviews)
4.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
(2 Reviews)
2.4
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
(5 Reviews)
2.2
$13 USD in 0 days
(1 Review)
1.4
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
(3 Reviews)
1.3
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
(1 Review)
0.4
Nurmaisharah

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

$25 USD in 1 day
(0 Reviews)
0.0
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
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
ViktorIvash

Hello. My name is Viktor. I can help you. I look forward to hearing from you.

$10 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
$25 USD in 1 day
(0 Reviews)
0.0