Working with Excel
Based on 300,000 lines. The phones are recorded in 1 cell by several pieces through a gap, folded, folded. It is necessary to break the numbers into several cells in the neighboring columns to get 1 phone number in the cell. I will review the cooperation both on the processing/adjustment to the required file type and the purchase of a macro that will solve this problem.
В базе 300 000 строк. Телефоны записаны в 1 ячейке по несколько штук через пробел, запятую, слитно. Необходимо разбить номера на несколько ячеек в соседние столбцы, чтобы получилось по 1 номеру телефона в ячейке. Рассмотрю сотрудничество как по обработке/приведению в необходимый вид файла, так и покупке макроса, который будет решать эту проблему.
В ячейке с номерами встречаются имена (текст), добавочные номера, которые необходимо убрать. Также номера нужны в виде 7ХХХХХХХХХХ, т.е. 7+код+семь цифр номера слитно без каких-либо знаков ()-+
В базе 300 000 строк. Телефоны записаны в 1 ячейке по несколько штук через пробел, запятую, слитно. Необходимо разбить номера на несколько ячеек в соседние столбцы, чтобы получилось по 1 номеру телефона в ячейке. Рассмотрю сотрудничество как по обработке/приведению в необходимый вид файла, так и покупке макроса, который будет решать эту проблему.
Возврат к изначальному заданию. Вопрос по корректировке и нужному виду данных решим самостоятельно.
Client's review of cooperation with freelancer
Working with ExcelGreat and work, great attitude! A true professional in his business. Thank you, pleased to cooperate!
![]()
Freelancer's review of cooperation with client
Working with ExcelSergey is very quickly and accurately answering the clarificing questions, the TZ is simple and understandable. It is a pleasure to work with Sergey.
![]()
-
Hello to you. Ready to perform in the best way. We have a great experience working with such tasks. I will bring the file to the right form and make a decision that will work after getting acquainted with the file. turn to
A systematic approach focused on your P&L and Cash Flow. I'd be glad to dive into your project details in private messages! -
276 4 1 1 Good day .
I will write a console program on C++, which will do everything you need and keep in the new table. If necessary, I can change the program later if additional sharing/extraction options are required.
I will go to work as soon as I get a file and detailed instructions from you.
Call to:
WhatsApp: 0637020242
Email: [email protected]
Twitter: Evgeniy59043757
Skype: live:dialectik_2
-
102 Good day .
Ready to get to work. I will be happy to cooperate. Write to LS.
-
242 Good day .
I want to offer a work option - a program on Delphi,
It will also work much faster than the VBA macros.
With this program you can process any number of files.
The program opens Excel files, read information from them,
compare and extract the result into the same or new Excel file.
I work with Excel tables without any problems (including formulas, colors, etc.).
So imports from Excel are implemented in the program for the General
I am a representative of the Nokia company in Armenia, and the conclusion (in Excel) is used as
… Alternative method of reporting.
I made a similar order recently.
With respect, Mike
Skype by: melqon.yesayan
-
12 Ready to do if it is relevant. Write to [email protected], telegram: @SergeyKSL
-
28 Hello, I was interested in your project. I guarantee fast and quality work. Term and price will be agreed.
-
194 12 0 Ready to carry out the task. I will do it in 3 days, maybe faster. Unfortunately, I can’t help with macros. If you have this option, please contact us. I will be happy to cooperate.
-
176 9 0 1 Hello to you. I do it quickly and quality! Write to the person or to the telegram https://t.me/slembo02/ I work on the freelance exchange https://studlance.ru/studlancer/16343, performed 350 or more orders
Processing the file in the necessary form.
-
250 37 1 2 Ready to work with the file and attach everything to the right look.
Details in LS
-
1483 57 2 1 Hello to you. I can implement a program that will carry out the necessary actions. You can use it in the future. I have experience with Excel. Ready to discuss details. I will be happy to cooperate.
-
227 19 1 1 Good day . Divide the records by comrades. For more accurate details, a file-example with input data is required.
-
126 1 0 Ready to help! I offer a script that will solve your problem.
If so, contact the person on the portal or telegram: @owndor
-
Здравствуйте.
Можно посмотреть документ?
-
Здравствуйте Сергей!
Можно пример файла в личку ?
Спасибо.
-
добрый день. на файл можно посмотреть
-
Киньте файл в личку. Возможно макросы не нужны. Надо бы глянуть
-
Current freelance projects in the category Databases & SQL
Database parsing
45 USD
Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group… Databases & SQL, Data Parsing ∙ 10 hours 47 minutes back ∙ 27 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 3 days 13 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 days 7 hours back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 5 days back ∙ 92 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 5 days 4 hours back ∙ 18 proposals |