Y
Y
Yastr2014-10-21 19:48:29
Database
Yastr, 2014-10-21 19:48:29

How to repeat the result of the CONCATENATE function a certain number of times in an exel cell with an increase of one digit?

Hello.
With zero knowledge of exel, I'm trying to create a database for my store, for the most part google helps, but there was a question that I could not find an answer to:
Let's say in column A, in each cell I have numbers from 3 to 10 - the number of photos
in column B is unique item number
column C should be formed based on the quantity in column A, and the number from B to the address (I have links to images), namely if A is 2 - B1;"/";"1";.jpg" ;",";B1;"/";"2";".jpg"
with a picture it will be clearer what it is about,
s3JnWBGtLx4.jpg
that is, I need to clone the link separated by commas as many times as indicated in A, I hope I explained it clearly)
please tell me how to implement it?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question