Break the data in the Excel cell into several columns using the formulas
4 USD Examples of the column:
253-255 Liverpool St, Hobart TAS 7000
156 Bathurst St, Hobart TAS 7000
108 Lansdowne Cres, West Hobart TAS 7000
99 Playford Ave, Whyalla SA 5600
3 Mills St, Whyalla Norrie SA 5608
At the exit, separate columns should be formed: address (without a back), city, region, index.
The result of the work is formulas, not concrete results.
Client's review of cooperation with Aleksandr Pomazun
Break the data in the Excel cell into several columns using the formulasThe task is fulfilled in full.
Freelancer's review of cooperation with Andrey Kuznetsov
Break the data in the Excel cell into several columns using the formulasEverything went greatly.
Thank you for the project!
-
1 day11 USD
421 13 0 1 day11 USD
Hello to you!
I work with Excel and Google tables.
Ready to help with the formula or macro (scripts).
I will be happy to cooperate.
-
1 day4 USD
397 7 0 1 day4 USD
Andrei, hello to you!
Ready to help you.
Experience with Excel in Portfolio.
-
1 day7 USD
48 1 day7 USD
Andrei, hello to you.
Ready to fulfill your task. I have a lot of experience working with Excel tables. I look forward to feedback. Responsibility and timing guaranteed
-
1 day4 USD
1528 147 0 3 1 day4 USD
The task is carried out in three steps.
5 minutes of time.
I will show you and explain how to do it.
200 rupees.
-
1 day7 USD
636 35 0 1 day7 USD
Good time of day. Interested in your task. For the idea for each column it will be necessary to write a separate formula, if it is suitable for you contact
Working through a safe deal
-
1 day4 USD
34 1 day4 USD
There is already a ready solution. Explanation of the Ls ........................
-
1 day7 USD
3593 250 0 1 day7 USD
Andrei, hello to you.
I will do the task in one hour.
Go to turn.
-
1 day4 USD
345 22 0 1 day4 USD
Hello to you. I am ready to do my job and I will be happy to work together. turn to
-
1 day6 USD
1134 38 0 1 day6 USD
Hello to you. Your formulas (the formulas) are ready. Write to LS.
-
1 day6 USD
853 48 0 1 day6 USD
Good evening .
Interested in your project. Ready to start right now.
I have great experience in Excel/Google Sheets.
with respect,
Dmitry
-
1 day7 USD
3621 113 7 1 1 day7 USD
I have an Excel program.
I work with formulas in practice.
Ready to get to work.
-
Макрос VBA под эксель Вам подойдёт?
-
Андрей, у вас не удачный парсинг данных или база.
Если и город, и штат будут состоять из двух и более слов, то никакая программа не спасет. Только вручную. (напр., Томс Ривер Нью Джерси)
-
Евгений, в примерах штат указан сокращенно.
-
а город?...
-
Город не критично, он будет остатком считаться.
Слева берем все до запятой, а потом идем справа по пробелам. Остаток - город.
-
в чем обычно делаете такое?
-
У нас офтоп начался. В Экселе длинными формулами.
-
Current freelance projects in the category Data Processing
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 1 day 3 hours back ∙ 14 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 1 day 3 hours back ∙ 16 proposals |
Digitization and structuring of official questions from the Traffic RulesLooking for a performer for technical work: transferring the official publicly available database of questions from the Traffic Rules (TR) into a structured Google spreadsheet and organizing accompanying images. Data Source Only the official state source — the Main Service… Information Gathering, Data Processing ∙ 3 days 8 hours back ∙ 22 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 3 days 12 hours back ∙ 10 proposals |
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 5 days 10 hours back ∙ 10 proposals |
Kyiv