Excel formula to lookup and extract address information

В роботі Опубліковано %project.relative_time Оплачується при отриманні
В роботі Оплачується при отриманні

I have a large excel spreadsheet - list of businesses. The address details are all in the one column. I need a formula to lookup and extract into separate columns the Suburb, State and Postcodes details

Excel

ID Проекту: #11147488

Про проект

21 заявок(-ки) Дистанційний проект Остання активність 7 роки(ів) тому

Доручено:

Teloquence

EXCEL/VBA expert at you service. Consider it done. Check my pa'st reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$20 AUD за 0 дні(-в)
(322 відгуків(-и))
7.6

21 фрілансерів(-и) готові виконати цю роботу у середньому за $25

nikhil08

Hi, Excel formula, macro is not possible, I will do manually. let me know if you are interested, so I will back to you with sample file.

$24 AUD за 1 день
(121 відгуків(и))
7.1
schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience . I assure you about the work quality and time delivery. Please give me chance to complete this project. I had already done the same work in pas Більше

$25 AUD за 1 день
(203 відгуків(и))
7.2
KulfiSoftwares

I know the formula. ZERO ERROR GUARANTEED!! Please read my reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We a Більше

$50 AUD за 0 дні(-в)
(182 відгуків(и))
7.0
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel project (with both macros and formulas) and i've never had a single problem. I m not bidding for manual dat Більше

$20 AUD за 0 дні(-в)
(316 відгуків(и))
6.5
BithiXpert

Hello Dear, I am an expert in Data Entry, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high qualit Більше

$25 AUD за 0 дні(-в)
(172 відгуків(и))
6.4
TonmoyRoy111

A proposal has not yet been provided

$25 AUD за 1 день
(222 відгуків(и))
6.3
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Більше

$20 AUD за 1 день
(112 відгуків(и))
6.4
rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before Більше

$20 AUD за 1 день
(94 відгуків(и))
6.1
catstevens2009

Hi there! Have done this type of work before and am an excel expert! Please feel free to message me with any additional information or with questions if any! Thanks! -Steve

$30 AUD за 0 дні(-в)
(73 відгуків(и))
5.5
LloydesignStudio

Hi sir, can you please send to me the excel file you want. i will take a look and make formula and send it to you. lets do it Thank you Lloyd

$30 AUD за 1 день
(39 відгуків(и))
5.3
JITINGOYAL1992

Greetings I am a Chartered Accountant (CPA/ACCA) providing financial consultancy services with major focus on accounts and excel. I have been engaged in this field for past 3 years and have served clients all over the Більше

$25 AUD за 1 день
(23 відгуків(и))
4.1
VinayOnTask

Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, dat Більше

$30 AUD за 1 день
(8 відгуків(и))
4.1
CreativeQueen

Hello, I'm ready now. So I'm interested in this job, please let me know, if I can support you. Thanks & Regards, Mitu Akter.

$15 AUD за 1 день
(20 відгуків(и))
3.7
JLQ006

I can do this job in 2 hours. If you award it to me now I can start working in it righy away.

$25 AUD за 1 день
(16 відгуків(и))
3.7
SVVP24

Hi, I will complete your work in given period of time with accuracy and quality. I have experience in data entry, Microsoft Office suites, Web Search, Web Scraping and copy typing. Please give me more details regard Більше

$20 AUD за 1 день
(1 відгук)
1.0
azanur007

I feel I can do this task for you. I am good at research and it will be great if we can discuss regarding your requirement.

$25 AUD за 1 день
(0 відгуків(и))
0.0
daymanvw

This may be a little tricky given the different permutations of format but not impossible, so long as the addresses at least adhere to a known set of formats.

$25 AUD за 1 день
(0 відгуків(и))
0.0
whitealien

Hi I looked at this as I was going to write a quick script in php to reprocess it all for you, but having looked at it I think that would not work. You are also going to struggle to put a formula in there simply beca Більше

$25 AUD за 1 день
(0 відгуків(и))
0.0