$5 to create a formula to seperate my data
$2-8 AUD / hour
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
Project ID: #9045342
About the project
36 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
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
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!
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
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
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
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.
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
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