Excel script/macro

Imefungwa Ilichapishwa Miaka 6 iliyopita Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

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

Uingizaji Data Kutengeneza Data Excel Software Architecture Visual Basic

Kitambulisho cha Mradi: #15675467

Kuhusu mradi

46 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

46 wafanyakazi huru wanazabuni wastani wa $22 kwa kazi hii

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 Zaidi

$60 USD kwa siku 1
(Maoni 346)
7.9
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 Zaidi

$10 USD kwa siku 0
(Maoni 206)
7.3
rexgant

Hi there, I offer this job to complete less than 1 day for $10 + system fee. I use not the only formula: replace/substitute but find and replace feature, filtering, etc. Relevant Skills and Experience I can handle tho Zaidi

$15 USD kwa siku 1
(Maoni 2)
3.0
mpunn2007

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

$15 USD kwa siku 1
(Maoni 9)
3.1
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 Zaidi

$25 USD kwa siku 1
(Maoni 2)
1.3
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 Zaidi

$20 USD kwa siku 1
(Maoni 4)
1.2
lahirusankalpa28

I can do it better Relevant Skills and Experience pdf excel/werd/copy paste Proposed Milestones $20 USD - inbox please

$20 USD kwa siku 1
(Maoni 0)
0.0
biplobhosain

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 Zaidi

$15 USD kwa siku 2
(Maoni 1)
0.0
bpatarlapalli

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 Zaidi

$25 USD kwa siku 1
(Maoni 0)
0.0
mohdlatief

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 Zaidi

$10 USD kwa siku 3
(Maoni 0)
0.0
ashakhatun1010

A proposal has not yet been provided

$15 USD kwa siku 3
(Maoni 0)
0.0
Asanka723

Hi there, I'm interested in your job post and I have all the skills for this job such as excel, data entry. Hope you will give me your job. Thank you. Relevant Skills and Experience Data entry, Excel Proposed Milesto Zaidi

$11 USD kwa siku 1
(Maoni 0)
0.0
Reenagiri

I will give my best ....

$10 USD kwa siku 1
(Maoni 0)
0.0
Wanadana

I can work by using excel,word Relevant Skills and Experience I feel like doing this project by using my excel,word knowledge

$25 USD kwa siku 1
(Maoni 0)
0.0
azieraazhar

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 Zaidi

$25 USD kwa siku 1
(Maoni 1)
0.0
nealchug

Hi, I’m Neal Chug, intermediate level in Excel / Macro and I would like to be part of your project. Thank you

$15 USD kwa siku 14
(Maoni 0)
0.0
ektuangel

A proposal has not yet been provided

$31 USD kwa siku 5
(Maoni 0)
0.0
srivasthan

I am an expert in VB applications and I can complete this within the specified time

$20 USD kwa siku 2
(Maoni 0)
0.0
sgu59fc1325b85a5

Have more than 7 years ex in these projects. Delivered such projects to GE, Barclays, Citi that are live.

$25 USD kwa siku 1
(Maoni 0)
0.0
Shadab1706

A proposal has not yet been provided

$25 USD kwa siku 1
(Maoni 0)
0.0