Excel script/macro
$10-30 USD
Paid on delivery
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
Project ID: #15675467
About the project
46 freelancers are bidding on average $22 for this job
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
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
I can do it better Relevant Skills and Experience pdf excel/werd/copy paste Proposed Milestones $20 USD - inbox please
I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Relevant Skills and Experience Data Entry, Data Processing, Excel, Software Architecture, Visua More
Hi I am Babu Patarlapalli currently working as a content writer for blog and very versed skill like content writing , content marketing and content processing which helps you to get your work done Relevant Skills and More
Hello, My name is latief a certified lead generation expert,got 6+ years of experience in lead generation. I have designed a tool that makes use of API technologies and i use that to generate leads. I am fully exper More
I can work by using excel,word Relevant Skills and Experience I feel like doing this project by using my excel,word knowledge
Hi, I am willing to do the project that you offer. In fact, I will ensure to do it exactly like you instructed. I will follow the format that you need. Relevant Skills and Experience I have experience in data entry b More
Hi, I’m Neal Chug, intermediate level in Excel / Macro and I would like to be part of your project. Thank you
Have more than 7 years ex in these projects. Delivered such projects to GE, Barclays, Citi that are live.
