Automated Replace Function Creation

Fermé Publié le il y a un mois Paiement à la livraison
Fermé Paiement à la livraison

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!

Saisie de Données Traitement de Données Excel Python Architecture Logicielle

Nº du projet : #38016104

À propos du projet

36 propositions Projet à distance Actif il y a 29 mins

36 freelances font une offre moyenne de 145 $ pour ce travail

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 Plus

$120 USD en 2 jours
(464 Commentaires)
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 Plus

$100 USD en 2 jours
(381 Commentaires)
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 en 2 jours
(220 Commentaires)
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 en 3 jours
(515 Commentaires)
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 en 2 jours
(451 Commentaires)
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 Plus

$250 USD en 7 jours
(23 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
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 Plus

$120 USD en 3 jours
(0 Commentaires)
0.0