How to merge data from excel/csv cells into one?

M

Masha Vorontsova2019-10-04 15:26:04

excel

Masha Vorontsova, 2019-10-04 15:26:04

On the server in the imgs folder there are a bunch of folders with product photos. Each folder name = item number. Each folder has an image 1.jpg
There is a table for import, where you need to write down for each article the path to its photo:
2 columns with data (article and link to the photo)

table

Артикул---|---Ссылка на фото
----------------------------------------------------
1221-------|---htps:/example.ru/imgs/***/1jpg
1331-------|---htps:/example.ru/imgs/***/1jpg
1144-------|---htps:/example.ru/imgs/***/1jpg

How to make in exel or openoffice so that there are articles instead of asterisks?

To make it like this

Артикул---|---Ссылка на фото
---------------------------------------------------------
1221-------|---htps:/example.ru/imgs/1221/1jpg
1331-------|---htps:/example.ru/imgs/1331/1jpg
1144-------|---htps:/example.ru/imgs/1144/1jpg

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Fedoryan, 2019-10-04
@FlyCope

=СЦЕПИТЬ("htps:/example.ru/imgs/";A1;"/1jpg")