Automated Replace Function Creation

Encerrado Postado 1 mês atrás Pago na entrega
Encerrado Pago na entrega

I need your help in creating an automated script or formula that can run multiple find-&-replace functions, at the same time, on an Excel spreadsheet that could regularly include 1,000 to 5,000+ records. Specifically, I will run this routine on the physical address column of data (not on the Company Name or City or State columns). In the attached .xlsx file, I would run the routine for all of a Column B.

Here are the 20 specific tasks involved:

1. If a cell contains the word "Ave" or "Ave.", it should be replaced with "Avenue".

2. If a cell contains the word "Blvd" or "Blvd.", it should be replaced with "Boulevard".

3. If a cell contains the word "Ct" or "Ct.", it should be replaced with "Court".

4. If a cell contains the word "Drive" or "Dr.", it should be replaced with "Drive".

5. If a cell contains the word "Expwy" or "Expwy." or "Epwy" or Epwy.", it should be replaced with "Expressway".

6. If a cell contains the word "Hwy" or "Hwy.", it should be replaced with "Highway".

7. If a cell contains the word "Ln" or "Ln.", it should be replaced with "Lane".

8. If a cell contains the word "Pkwy" or "Pkwy.", it should be replaced with "Parkway".

9. If a cell contains the word "Rd" or "Rd.", it should be replaced with "Road".

10. If a cell contains the word "St" or "St.", it should be replaced with "Street".

11. If a cell contains the word "1st", it should be replaced with "First".

12. If a cell contains the word "2nd", it should be replaced with "Second".

13. If a cell contains the word "3rd", it should be replaced with "Third".

14. If a cell contains the word "4th", it should be replaced with "Fourth".

15. If a cell contains the word "5th", it should be replaced with "Fifth".

16. If a cell contains the word "6th", it should be replaced with "Sixth".

17. If a cell contains the word "7th", it should be replaced with "Seventh".

18. If a cell contains the word "8th", it should be replaced with "Eighth".

19. If a cell contains the word "9th", it should be replaced with "Nineth".

20. If a cell contains the word "10th", it should be replaced with "Tenth".

NOTE 1: I do NOT want the routine to find & replace any of the abbreviations, like "St" in the Proper Name of the Ave/Blvd/Ct/etc.

For example, I would NOT want a "123 Strausburg St." address to turn into "123 Streetrausburg Street".

This note would equally apply to "Ave/Ave", "Blvd", "Ct", "Dr", "Expwy", "Epwy", "Hwy", "Pkwy", "Rd".

NOTE 2: I do NOT want the routine to find-&-replace:

"123 Strausburg St., S.W."/"123 Strausburg St., SW"/"123 Strausburg St. S.W."/"123 Strausburg St. SW",

with:

"123 Strausburg StreetS.W." or "123 Strausburg StreetSW"

In other words, I do not want to lose the appropriate "space/spacebar" between the "Street" and "S.W." (or "SW"). In my experience, it has been too easy to miss this pesky space/spacebar.

NOTE 3: I would expect to receive the routine to be given to me in such a way that I could paste into my spreadsheet.

NOTE 4: I would expect that I could add, in the future, additional "street"-like names into the routine, assuming it was intuitive, OR, I would need written-out instructions (if it was not intuitive).

Required skills and experience:

- Proficient in Microsoft Excel

- Experience in creating formulas or scripts for automated processes

- Attention to detail for accurate data replacement

I require this script or formula to be implemented as soon as possible. Looking forward to your applications!

Processamento de Dados Processamento de dados Excel Python Arquitetura de software

ID do Projeto: #38016104

Sobre o projeto

36 propostas Projeto remoto Ativo em há 4 semanas

36 freelancers estão ofertando em média $145 nesse trabalho

AishaAlimuhammad

Hello, I can create a script that would replace all the above mentioned words in address column with the abbriviation. I have a few questions which we could discuss before starting the project. You will be able to use Mais

$120 USD in 2 dias
(464 Comentários)
9.2
livegoodlife

Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bo Mais

$100 USD in 2 dias
(381 Comentários)
8.1
lkhelladi

Hello, I'd be glad to develop the automated function for running multiple find and replace operation on excel sheets. Looking forward to chat with you soon for more details. Best regards. Lyes.

$220 USD in 2 dias
(220 Comentários)
8.0
P0L

Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD in 3 dias
(515 Comentários)
8.1
prameswara

Hi Sir Im excel vba macro and formula expert I can make vba for find and replace scritp like you need Please ping me now and im feee now Thank you Sincerely Galih

$95 USD in 2 dias
(451 Comentários)
7.7
ahmadayaz

Hi, With over a decade of experience in Full Stack Development and Data Management, I am confident that I can provide the automated replace function you need for your Excel spreadsheet. My proficiency in Microsoft Exce Mais

$250 USD in 7 dias
(23 Comentários)
6.9
AmirShahzad2020

I will give this script or formula to be implemented as soon as possible. I will charge only $30. Let me know if you are interested? Regards, Amir

$30 USD em 1 dia
(8 Comentários)
4.3
TayyabDastgir

Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For Mais

$30 USD em 1 dia
(7 Comentários)
3.2
pivendev

Dear Paul S. This project seems a very fit work for me. I had done exactly the same work a month ago. I would like to grab this opportunity and will work till you get 100% satisfied with my work. I have many years Mais

$120 USD in 3 dias
(0 Comentários)
0.0