$5 to create a formula to seperate my data

Closed Posted Dec 4, 2015 Paid on delivery
Closed

Dan26kk2k5;sajhiqxo;vszwauxzp6"at"[login to view URL];

Sinhdy4j76t9;cf9vmz8h;mv768o0wja"at"[login to view URL];

The "at" is actually an "@"

This is the type of data I have. The amount of characters between each semi colon varies.

But I need a formula to use in excel that can make the data look like this.

Dan26kk2k5:sajhiqxo

Sinhdy4j76t9:cf9vmz8h

Excel

Project ID: #9045342

About the project

36 proposals Remote project Active Jan 10, 2016

36 freelancers are bidding on average $5/hour for this job

TypingxpertRehan

you can simple use data to text, and seperate through semi column, its simple, i can teach you how to do, pm? thanks

$5 AUD / hour
(1262 Reviews)
9.2
Webxpert4u

Hello, Please send me whole file and get the updated file as you requested within 15 minutes. I can do it by few clicks for whole list, without formula. Let's Discuss. Looking forward to hear back. Thanks, Warm Regards

$8 AUD / hour
(409 Reviews)
8.5
SBITServices

A proposal has not yet been provided

$5 AUD / hour
(452 Reviews)
7.7
zExcel

A proposal has not yet been provided

$8 AUD / hour
(251 Reviews)
7.7
someka

A proposal has not yet been provided

$5 AUD / hour
(141 Reviews)
7.2
ZedExcel

Hello. I am proficient with Excel formulas and will be glad to work on your project. My priority is to deliver working solutions to my employer without unnecessary delays. With that in mind, a formula has already been More

$5 AUD / hour
(35 Reviews)
7.2
best4best

Do you want to replace all semicolons with colons ? Or only first semicolon with colon and second semicolon with Tab? Please clarify or provide the Excel file itself with example. Thanks!

$8 AUD / hour
(148 Reviews)
6.4
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I have a solution ready for you. In my approach you'll More

$4 AUD / hour
(64 Reviews)
5.7
archanaoswal

I can do it in the next 1 hour

$5 AUD / hour
(81 Reviews)
5.9
SidraMalik13

A proposal has not yet been provided

$5 AUD / hour
(10 Reviews)
4.3
slenders13

Dear client, I can write a macro for this. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

$5 AUD / hour
(15 Reviews)
4.4
magentapowa

Hello What format does the data have? What I will do is create a txt or csv file and then input it in an excel file setting it as semi colon separated. I have a lot of experience handling data and working on excel. More

$5 AUD / hour
(29 Reviews)
4.3
y2klewis

Hi, my name is Daniel, i am an excel expert and vb programmer, i am sure that i can create any formula to fit your requirement

$5 AUD / hour
(14 Reviews)
4.0
adicoman

Hi, I am very interested to work on your project. I have 11+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile develo More

$20 AUD / hour
(2 Reviews)
3.8
marianodonato

I can do this with a formula and a macro so you can use this for further data. I can do this in less than a day.

$5 AUD / hour
(9 Reviews)
3.4
sujata87mishra

Hi - I can get this done as expected by you........ Let me know we can discuss more in chat. Thanks

$5 AUD / hour
(7 Reviews)
3.1
joydeepdam

Hello, I am very much interested in your project. Being a data analyst, I have daily association with data processing in Excel. I can help you solving this using semicolon separator and finally concatenation between More

$5 AUD / hour
(7 Reviews)
3.3
deescorp

A proposal has not yet been provided

$5 AUD / hour
(1 Review)
1.3
zaskock

Hello! I'm interested in your project, let's discuss the details? Feel free to send me a text message via chat or s-k-y-p-e: zaskock (usually on-line from 12:00 to 23:00 UTC+2) - You don't need even formula to so More

$5 AUD / hour
(2 Reviews)
1.0
vishaljangra49

I'm known as master of excel i'll do it now just accept my bid i knows many formula of excel because i have been worked in many official lines

$5 AUD / hour
(0 Reviews)
0.0