2022-11-22

Is it possible to find and delete anything between two specified characters in an excel csv cell?

I have a csv file, where images links are added in one cell for one product. I want to remove text form ? to ,

I write this code:

=MID(A2,1,FIND("?",A2)-1)&MID(A2,FIND(",",A2),LEN(A2))

But its applied only on the first image link.

This is what I have:

/images/image1.jpg?1200x800=new, /images/image2.jpg?1200x800=new,/images/image3.jpg?1200x800=new, /images/image5.jpg?1200x800=new

Result I need:

/images/image1.jpg,/images/image2.jpg,/images/image3.jpg,/images/image5.jpg


No comments:

Post a Comment