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
-
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.
-
234 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
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 14 hours 59 minutes back ∙ 12 proposals |
Vibe coding through Claude Code
350 USD
Develop a closed web platform for corporate events with personal invitations via unique links and QR codes. After scanning the QR code, the user is directed to a personal invitation page with a welcome message, a greeting by name, a photo and a message from the CEO, a countdown… AI Art, Databases & SQL ∙ 18 hours 8 minutes back ∙ 39 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 22 hours 29 seconds back ∙ 33 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORPAbout the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 4 days 22 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 5 days 1 hour back ∙ 19 proposals |