how to populate a cell with value from another cell plus some added text?

[Danthes]

Hello and thanks for this forum.
Im using MS Office 2010 Pro.
Im working with CSV tabels, can you help me populate the cell B and C as follow:

A	B	C
bau101 <tbody> </tbody>	data/bau101.jpg <tbody> </tbody>	data/bau101_2.jpg:::data/bau101_3.jpg <tbody> </tbody>

<tbody>
</tbody>

from the value inserted in collumn A to fill B and C with coresponding paths, all images are in the same location. In short: if the cell A is filled by me with "zxc100", the cell B will be filled with "data/zxc100.jpg" and cell C with "data/zxc100_2.jpg:::data/zxc100_3.jpg", the formula must be active for the entire collumn.

Thanks in advance, have a nice day.

 

[antti]

Hi Danthes,

Try the following formulas:
- column B: ="data/"&A2&".jpg"
- column C: ="data/"&A2&"_2.jpg:::data/"&A2&"_3.jpg"

If the name of the folder 'data' is not fixed, you can specify that in another column and use the same concatenation logic as above.

 

[Danthes]

Thanks for fast reply,
it works as i want to if i replace "A2" with "A1"

Thanks alot, have a nice day.