Recent content by luis_marques

Excel Wizard, thanks for both solutions in the Sample.xlsx and also for Power Query code (straightforward approach). Best Regards.

Many thanks, Bosco.

Perfect. Many thanks for your help.

Thanks. That is what i need. How do i inform pivot table to split data in the AT column?

Hi, Our ecommerce is hosted in a cloud plataform. The only format they offer to export order data is attached. I kept just 3 original rows for security reason. With this file in hand i use the macro in the SAMPLE.xlsx to split single cell data (Column AT) in several columns in a different...

P45cal, it is a weird format. More weird is that those columns are extracted from just one cell. I use a macro to extract information. See attached. I would appreciate a lot if you could help to solve this.

Hi. Any help? Please

Hi, I have a sheet where each row is an order. Each order may have since 1 product until n products. The export file of this data order present a pattern of data that repeats every each 14 columns for each product Those 14 columns are data of just 1 product of 1 order. I need to multiply 2...

Hi, I need to replace old URLs for new ones, but i need capture text from de field called NOME (Name in english). For instance in the column A: NOME Roupa PJ Masks - Blusa PJ Masks - Corujita - Cinza - Malwee Then i need to format like this in a new column: NEW URL...

Thanks. It is a very interesting approach to display such data.

Perfect. It worked very well. Many thanks.

I attached a sample. Column A, several lines with information that need to be extracted right to next column like in the yellow cells in the sample.

Many thanks. I didn´t notice. Sorry. Is possible to make this VBA operation for many lines at same time and each line extracted to start at the right next column of original ones?

Thanks Bosco. How could be using VBA?

Yes, indeed i missed. I corrected, but extracted just one set of information. The second set or more the formula doesn´t extract.