Share via

EXCEL: REMOVE PRODUCT SIZE / REMOVE SUFFIX

Anonymous
2022-04-15T10:04:29+00:00

Hi,

My product variants have the size at the end of each variant, however I want to remove the size and just keep product code. I have tried substitute but in Excel version I am using it will only let me enter certain amount. Is there another way? I am using a MAC.

E.G

CWNOS01RPLN20-XXS - would become CWNOS01RPLN20

CWNOS01RPLN20-XS - would become CWNOS01RPLN20

CWNOS01RPLN20-S - would become CWNOS01RPLN20

CWNOS01RPLN20-M - would become CWNOS01RPLN20

CWNOS01RPLN20-L - would become CWNOS01RPLN20

CWNOS01RPLN20-XL - would become CWNOS01RPLN20

CWNOS51CPLN20-18 - would become CWNOS51CPLN20

CWNOS51CPLN20-20 - would become CWNOS51CPLN20

CWNOS51CPLN20-22 - would become CWNOS51CPLN20

CWNOS51CPLN20-24 - would become CWNOS51CPLN20

CWNOS51CPLN20-26 - would become CWNOS51CPLN20

CWNOS51CPLN20-28 - would become CWNOS51CPLN20

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-15T12:44:55+00:00

    Hi Joe

    You may find in the link below a fully automated version that combines all your questions in the forum using Power Query you might to consider

    https://we.tl/t-dC6pa7RDOI

    You simply need to

    On the Input Data tab

    1. Add at the bottom of the table or Replace the data in the Orange table with all the product codes

    Image

    1. Update/Add/Complete the tables with their corresponding values in the Tables sheet

    Image

    1. Then go to Data>>Refresh>> Refresh All

    Image

    I hope this also helps you

    Regards

    Jeovany

    0 comments