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

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.

Igor Igor
Kyiv, Ukraine

Projects 14
Rating 5.0
Rating 436

Create macro for Excel for Mac OS and Windows

Client's review of cooperation with Oleksandr Nazarov

Create macro for Excel for Mac OS and Windows

5.0

Igor Igor

Freelancer's review of cooperation with Igor Igor

Create macro for Excel for Mac OS and Windows

5.0

Oleksandr Nazarov

Oleksandr Nazarov

Oleg M.

Proposals are currently absent

Current freelance projects in the category Desktop Apps

Linux mentor

Microsoft Power Platform/Power App