Excel Trim
$10-30 USD
Paid on delivery
I have a sheet with 2 columns.
Column 1 = full address
Column 2 = city
I need a formula that says: IF "city" exists in "address", then delete city in address, delete comma "," before it, and all text after it.
column 1 (city): Flagstaff
column 2 (address): 3101 N Fort Valley Rd, Flagstaff Arizona 86001 USA
If "City" is "Flagstaff", then final address output would change to: 3101 N Fort Valley Rd
Project ID: #14296979
About the project
Awarded to:
Hi, I am good at Excel and formulas. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra
23 freelancers are bidding on average $21 for this job
Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done More
Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the informatio More
Hello, Expert here. Ready to start. Let me do this work with perfection, accuracy and according to your requirements, please contact with me so we can discuss further about the project. I surely would welcome the n More
Hi, First! Your satisfaction is my top priority.I am really interested in your project about Excel Trim. If you give me chance then i can start right now and able to provide best results. In short, I could produce More
Hi, My core expertise is in excel, online data processing, data mining, online research projects. Follows instruction and do pay close attention to details. Looking forward for your reply Thanks
Dear client, I have understood your project and I hope I seriously complete your jobs.I can make anything you want, if you can describe exactly what you want, will get the exact service until full satisfaction . More
hello sir i can do that in few hours ..... i am an expert in excel and have done many such projects in past with excellent ratings so please msg me to discuss thank you hope to hear from you
Dear Clint, I read your project posting. I'm understanding your requirement for this job. I've more than 3 years experience in related field. I've experience in Data entry,Data Processing, Internet Research, PDF More
Hello, I checked your attachment. I have extensive experience in data entry, data processing ,excel. I can do your project in according to your description with full delivery and without error. I would also complete yo More
My advance skills in Excel application makes me confident that I will accurately deliver this work within the shortest time possible. Kind regards
I am a skilled data entry and research expert with a professional mastery of Microsoft Excel acquired over seven years of active freelancing on other sites. Feel free to let me handle your project. Thank you