Insert content from another cell

  • Thread starter Thread starter januszjasinski
  • Start date Start date
J

januszjasinski

Yup,

I know how to get data from a different cell on the same worksheet int
another cell. However, what I want is for some text to come before it.

I have a column with 1000 rows. Each cell has the text
PRODUCT/IMAGES/

I want to insert the code after the "/" which calls another column
Logically, something like:

PRODUCT/IMAGES/*=$A$1*.jpg

Basically, the data I want to pull is in between the *

Hope this make sense!

Thanks
 
Hi

Case 1: The content of A1 is added to text in every row:
Enter
="PRODUCT/IMAGES/" & $A$1 & ".jpg!
into any cell, und copy to whole range of 1000 cells.

Case 2: The content of cell in column A on same row is added to text:
Enter into 1st row the formula
="PRODUCT/IMAGES/" & $A1 & ".jpg!
and copy down for all 1000 rows.

Case 3. Same as 2, but you want insert values from column A from another
sheet (p.e. Sheet 2):
The formula for 1st row
="PRODUCT/IMAGES/" & 'Sheet 2'!$A1 & ".jpg!
And copy down.
 
Wow,

Cheers - I actually ended up using the concatonate (spelling?)
function.

Thanks!
 
Back
Top