Find Jobs
Hire Freelancers

Quick Excel Replace Formula

$10-30 USD

Terminado
Publicado hace alrededor de 10 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 5732696

Información sobre el proyecto

38 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 0 día
4,9 (175 comentarios)
7,1
7,1
38 freelancers están ofertando un promedio de $18 USD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (87 comentarios)
7,4
7,4
Avatar del usuario
Dear tnt08vsn. Consider it done. Let me handle it. I can provide you formula immediately. Wait for your awrading. Thank you
$10 USD en 0 día
5,0 (139 comentarios)
6,8
6,8
Avatar del usuario
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 en 0 día
4,9 (90 comentarios)
6,6
6,6
Avatar del usuario
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 en 0 día
4,8 (41 comentarios)
6,3
6,3
Avatar del usuario
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 en 0 día
4,9 (112 comentarios)
6,4
6,4
Avatar del usuario
Formula ready for you, Thank you
$14 USD en 0 día
4,9 (51 comentarios)
6,2
6,2
Avatar del usuario
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 en 1 día
4,8 (51 comentarios)
5,7
5,7
Avatar del usuario
Hello, I can do in less than 5 minutes. Please send the excel file. Looking forward for the reply. Regards, Aditya
$10 USD en 0 día
5,0 (145 comentarios)
5,5
5,5
Avatar del usuario
Your file is rady pm me fast to get the file now NOW pm me ...................................................... .............. I send you the excel file now
$35 USD en 0 día
5,0 (38 comentarios)
5,4
5,4
Avatar del usuario
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 en 0 día
4,9 (62 comentarios)
5,2
5,2
Avatar del usuario
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 en 0 día
4,9 (7 comentarios)
4,2
4,2
Avatar del usuario
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 en 1 día
5,0 (7 comentarios)
4,1
4,1
Avatar del usuario
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 en 0 día
4,7 (18 comentarios)
3,6
3,6
Avatar del usuario
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 en 1 día
5,0 (6 comentarios)
3,5
3,5
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
3,3
3,3
Avatar del usuario
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 en 0 día
5,0 (10 comentarios)
2,9
2,9
Avatar del usuario
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 en 1 día
3,8 (13 comentarios)
3,8
3,8
Avatar del usuario
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 en 0 día
5,0 (2 comentarios)
2,8
2,8
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
1,8
1,8

Sobre este cliente

Bandera de UNITED STATES
Valley Village, United States
5,0
25
Forma de pago verificada
Miembro desde abr 3, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.