How to remove text between commas in Excel?

D

Daulet2021-08-20 15:46:13

excel

Daulet, 2021-08-20 15:46:13

Good afternoon, I have an Excel file in which there is a column with links to photos (uploaded xml file). There are 2 or more photos (sometimes up to 10 photos). All of them are separated by commas, how to leave only 3 photos per line. Maybe there are some regular expressions with which you can quickly implement all this?
Source line:

https://img.ltwebstatic.com/images3_pi/2021/04/07/16177590108b24ec30623f656ba09b7fb320716437.jpg, https://img.ltwebstatic.com/images3_pi/2021/04/07/161775901290753738d0109745d7969ecfe920e536.jpg, https://img.ltwebstatic.com/images3_pi/2021/04/07/16177590173ff7a09ed8bd937f8a3f5d967dcb7f98.jpg, https://img.ltwebstatic.com/images3_pi/2021/04/07/16177590193f249e9d4730f68290be20424cd3bb0b.jpg

Should stay like this:

https://img.ltwebstatic.com/images3_pi/2021/04/07/16177590108b24ec30623f656ba09b7fb320716437.jpg, https://img.ltwebstatic.com/images3_pi/2021/04/07/161775901290753738d0109745d7969ecfe920e536.jpg, https://img.ltwebstatic.com/images3_pi/2021/04/07/16177590173ff7a09ed8bd937f8a3f5d967dcb7f98.jpg

Screenshots:
https://i.yapx.ru/N0wqQ.png
https://yapx.ru/v/N0wqK

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)