Insert content from another cell

Yup,

I know how to get data from a different cell on the same worksheet into
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!


---
Message posted from http://www.ExcelForum.com/

One way:

="PRODUCT/IMAGES/" & A1 & ".jpg"


In article ,
januszjasinski wrote:

Yup,

I know how to get data from a different cell on the same worksheet into
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!


---
Message posted from http://www.ExcelForum.com/

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.


--
(When sending e-mail, use address )
Arvi Laanemets


"januszjasinski " wrote in
message ...
Yup,

I know how to get data from a different cell on the same worksheet into
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!


---
Message posted from http://www.ExcelForum.com/

Wow,

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

Thanks!


---
Message posted from http://www.ExcelForum.com/