$5 to create a formula to seperate my data

Closed Posted Dec 4, 2015 Paid on delivery
Closed

Dan26kk2k5;sajhiqxo;vszwauxzp6"at"[url removed, login to view];

Sinhdy4j76t9;cf9vmz8h;mv768o0wja"at"[url removed, login to view];

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

37 proposals Remote project Active Jan 10, 2016

37 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
(520 Reviews)
8.0
zExcel

A proposal has not yet been provided

$8 AUD / hour
(215 Reviews)
7.3
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
(104 Reviews)
5.9
someka

A proposal has not yet been provided

$5 AUD / hour
(68 Reviews)
5.7
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
(52 Reviews)
5.7
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
(58 Reviews)
5.7
SBITServices

A proposal has not yet been provided

$5 AUD / hour
(41 Reviews)
5.3
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
(13 Reviews)
4.1
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
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
(7 Reviews)
3.5
sujata87mishra

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

$5 AUD / hour
(6 Reviews)
2.6
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
(5 Reviews)
2.6
masud4096

Dear Hiring Manager, I can do the task with zero error and best quality that you want. Please consider a discussion with me Sir. Thank you, Masud

$4 AUD / hour
(3 Reviews)
2.1
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
(6 Reviews)
2.1
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
(4 Reviews)
1.7
deescorp

A proposal has not yet been provided

$5 AUD / hour
(1 Review)
1.3
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
(2 Reviews)
1.3
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
khansohrabali

Hi, hire me and get 100% result. I am offering my services for this job. Regards, sohrab ali skype. khansohrabali

$2 AUD / hour
(0 Reviews)
0.0