Find Jobs
Hire Freelancers

Quick Excel Replace Formula

$10-30 USD

Completed
Posted about 10 years ago

$10-30 USD

Paid on delivery
Need a quick formula that would change the last few characters of a sku to "INT". The characters will be a mix of letters and numbers and will vary in length. You will change only the characters to "INT" after the 2nd "-" Examples: J0-JQ51-M4YX would change to: J0-JQ51-INT V6-MPG7-FF would change to: V6-MPG7-INT GH-P0F-45768 would change to: GH-P0F-INT Should just take a couple minutes for someone with experience.
Project ID: 5732696

About the project

38 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Here's the formula: =CONCATENATE(LEFT(A1,LOOKUP(2^15,FIND("-",A1,ROW(INDIRECT("1:"&LEN(A1)))))-1),"-INT") . Pay me if you want to.
$10 USD in 0 day
4.9 (175 reviews)
7.1
7.1
38 freelancers are bidding on average $18 USD for this job
User Avatar
Hi Tn08. As you correctly said, it is not more than half an hour job to get the work done. Kindly share the sheet so I may have a look. Regards. Usman.
$30 USD in 1 day
5.0 (87 reviews)
7.4
7.4
User Avatar
Dear tnt08vsn. Consider it done. Let me handle it. I can provide you formula immediately. Wait for your awrading. Thank you
$10 USD in 0 day
5.0 (139 reviews)
6.8
6.8
User Avatar
Hello, It's a matter of a few minutes for me. I'm a trainer in Excel and VBA for 12+ years, so you can guess that I have created a lot of similar formuale. Looking forward to hear from you, Kind regards, chriskerpini
$17 USD in 0 day
4.9 (90 reviews)
6.6
6.6
User Avatar
I am specialize in C++,C#.net,ASP.Net,JAVA, PHP, MySQL, Wordpress, Web Designing and framework like CodeIgniter. my aim to deliver quality products to our customers within specified deadline. If hired by you I will put in my best work. I am ready to be hired by you and start work on your jobs PM to me for more discussion.
$30 USD in 0 day
4.8 (41 reviews)
6.3
6.3
User Avatar
Hello, I am very much interested to do this work. It's very easy. I already did it. Just accept my bid & get the result instantly. Thanks
$10 USD in 0 day
4.9 (112 reviews)
6.4
6.4
User Avatar
Formula ready for you, Thank you
$14 USD in 0 day
4.9 (51 reviews)
6.2
6.2
User Avatar
Hi We can achieve that in a quick time. Please send us the excel where you want this formula to be implemented. Thanks Gopisoft Private Limited
$25 USD in 1 day
4.8 (51 reviews)
5.7
5.7
User Avatar
Hello, I can do in less than 5 minutes. Please send the excel file. Looking forward for the reply. Regards, Aditya
$10 USD in 0 day
5.0 (145 reviews)
5.5
5.5
User Avatar
Your file is rady pm me fast to get the file now NOW pm me ...................................................... .............. I send you the excel file now
$35 USD in 0 day
5.0 (38 reviews)
5.4
5.4
User Avatar
Hello ready to start asap to deliver you, I have done similar project, if you like I can send a free sample to you, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. About me solution: We must find the last dash and then we replace INT after it.
$17 USD in 0 day
4.9 (62 reviews)
5.2
5.2
User Avatar
Hi, I have good experience with VB programming and I would like to bid for this project. Here is the steps: - Insert a string to s - Split the string using delimiter "-" - Replace the last component by "INT" - Rejoin all string components with "-" - Save the string. Hope you will hire me. Tks.
$30 USD in 0 day
4.9 (7 reviews)
4.2
4.2
User Avatar
I'm a kind of an expert in excel, and I can write this function that you want. Hope you choose me, and either way, good luck with whom ever you do choose.
$15 USD in 1 day
5.0 (7 reviews)
4.1
4.1
User Avatar
Hello sir, I am ready to do it, please give me source file so i can prepare for sample, please PM me for better discuss, awaiting for your positive response, thanks.
$20 USD in 0 day
4.7 (18 reviews)
3.6
3.6
User Avatar
Did you find anyone yet? I am American, live in NYC, have a BS and a day job; I need extra projects this month. I am free to talk on the phone as well anytime. Regards, Joe
$30 USD in 1 day
5.0 (6 reviews)
3.5
3.5
User Avatar
Hey there. I work as a Data Analyst at my day job so I'm on Excel all day. Could you send me a message with the file? I want to try it out. I think I can have this completed in two minutes.
$12 USD in 1 day
5.0 (3 reviews)
3.3
3.3
User Avatar
hello warm greetings.. I'm an engineering student. Currently hired by IBM will do this within a hour.. have done similar functions for my employer(he was a amazon seller). also i have coded a macro that replaces accented character to regular alphabets kindly check my employer reviews regards
$30 USD in 0 day
5.0 (10 reviews)
2.9
2.9
User Avatar
Hello there, It is my great honor to apply for this job vacancy. I am very hardworking and can work effectively as fast as I can. I have excellent skills in Data Entry, Web Research and Microsoft Office and I have enough experience with different kinds of tasks as you can see in my "Work History", most of the time I gave my clients a great result. I have a fast internet connection at home, have my own PC to use anytime and have own space to work. I can work full time and will focus on this project. I can follow instructions very well and will deliver the project on time. It is a pleasure if ever you will message me for an interview. I can work as soon as possible. Thanks
$25 USD in 1 day
3.8 (13 reviews)
3.8
3.8
User Avatar
It's very easy, you do the following: Convert text to columns by using "-" as a separator. Then re-merge the first two columns and a text "-INT" I'll appreciate if you chose me, I am a newcomer and need some initial ratings :) Thank you
$15 USD in 0 day
5.0 (2 reviews)
2.8
2.8
User Avatar
Hi, I have the formula ready. I won't be able to stay on for much longer, so please act quickly if you'd like it from me. Thank you, -David
$15 USD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
Hi, I understand exactly what needs to be done. I am new to freelancer but very enthusiastic and hard-working. You can check on my review to know more about my work. I can work on this project immediately with 100% quality and accuracy guaranteed. Please award me and you will be glad you did. Thanks & Regards, Sonika.
$25 USD in 1 day
5.0 (3 reviews)
1.8
1.8

About the client

Flag of UNITED STATES
Valley Village, United States
5.0
25
Payment method verified
Member since Apr 3, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.