$5 to create a formula to seperate my data
$2-8 AUD / hour
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
Project ID: #9045342
About the project
37 freelancers are bidding on average $5/hour for this job
you can simple use data to text, and seperate through semi column, its simple, i can teach you how to do, pm? thanks
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!
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
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
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
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
Hi - I can get this done as expected by you........ Let me know we can discuss more in chat. Thanks
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
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
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.
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
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
Hi, hire me and get 100% result. I am offering my services for this job. Regards, sohrab ali skype. khansohrabali