Search results

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.

Thanks Shrivallabha! I tried to implement, but i don't know whats was wrong. That is a sample of my database. In the yellow cell i typed your formula. Could you verify, please?

Anyone could help?

Bosco Hi, it works very well if i have two until three products (codes), but it doesn´t work if i have more than 3. What could be possible to deal with such problem? Every new product is recognized when you see: },{ One example of set of products in just a single cell...

Many thanks Bosco.

Hi, is that ok, or you need anything more detailed?

I posted a sample of sheet. Thanks for your assessment.

Hi, I made a drawing to explain my need. I have a sheet in woorkbook that is a source where each row is a order. New orders are always in the new rows that are being created and going down. I need to copy a model sheet in the wookbok for each order created. Then fill data from the source...

Hi , I need a formula to read a single cell and extract data to multiple columns like the attached example. Some criteria: 1. Data between comma and colon 2. Remove quotes 3. Remove brackets 4. Remove braces

Thanks. Worked fine.

Hi, I posted the table in order to make clear. Please, i need to match a zipcode in one column in another full column. Then i need to extract the risk index from a third column to matched zipcode. Thanks in advance.