Project translated automatically. Log in or register, to view the original TZ It is necessary to make a macro in EXCEL, which brings the data in the correct form.Macro should work both on Windows and MAC OS (there are 2 macros for different OS) In the first column of the EXCEL file we will enter the data.(Many lines at the same time) The second column will contain the buttons to get the result. 3 columns = (individual number of position) From the data of the first column of the corresponding line there are numbers equal or longer to 4 characters, which may include letters. If in the first column there are two such numbers, then there falls first a longer number and through the gap next "(" short number ")" 4 columns = (named) Here the word or several words pass through the gap that is contained in the corresponding column of the first line (symbols there may be) Words are longer than two symbols (signs in length are not considered) Excluding the words:The couple.and comp.Completed , st If not, then leave it empty. 5 columns = (columns) Search for separate numbers in 1 column of the corresponding line (the closest to the left boundary of the cell) not more than 99 or not price numbers example:1.7 not more than 99 If not, then leave it empty. 6 columns of measurement Search in the first column and the corresponding line of the word:The couple.and comp.Complex, M and M,m and put them in column 6 (if they are) If not, leave it empty 7 columns ( price ) Search for the numbers after which there is the name of the euro and before which there is "-" and put them in the cell / You need to make the second version of this column (Seek the numbers near the right edge and before which there is "-" and put them in the cell) If not, then leave it empty. Column 8 number This is a short number like in column 3, but only a short number. If not, then leave it empty. Column 9 number This is a "long number" like in column 3, but only a long number. If not, then leave it empty. For those interested in the project, I can send examples of files.

Proposals 2

Oleksandr Nazarov

Winning proposal

15 0

Projects 16
Rating -
Rating 788

Budget: 1000 UAH Deadline: 2 days

Good night, I will do it, call me. Here is an example of the file. It will work on both systems if you have MS Office installed on the Mac.
and ........................

Oleg M.

109 0

Projects 105
Rating -
Rating 1 115

Budget: 200 UAH Deadline: 1 day

Good day Igor.
Write to Ls, we will discuss the details. You need original files.

Current freelance projects in the category Desktop Apps

Need to transfer the site from Webflow to WordPress.

Web Programming 65 proposals 3 August

Not specified
Refinement of the CRM in 1C: displaying the client's bonus balance

Testing & QA 12 proposals 29 July

Not specified
Setting up multiple Viber accounts on one remote desktop

13 proposals 28 July

Not specified
Light application

PHP 67 proposals 28 July

172 USD
App : Digital Marketplace for Skilled Trades in Morocco

Web Programming 66 proposals 22 July

500 USD

Igor Igor
Kyiv, Ukraine

Projects 14
Rating 5.0
Rating 423

Igor Igor

Oleksandr Nazarov

Oleksandr Nazarov

Oleg M.

Proposals are currently absent

Current freelance projects in the category Desktop Apps

Need to transfer the site from Webflow to WordPress.

Refinement of the CRM in 1C: displaying the client's bonus balance

Setting up multiple Viber accounts on one remote desktop

Light application

App : Digital Marketplace for Skilled Trades in Morocco