Formula needed

G

Guest

I have a spreadsheet that I need to add numeric information from one cell,
into another cell on the same row, that has a text string.

For example, I need the numbers: 64001005 from cell A1 to be added in cell
c1 along with the text: productimages/ (with the forward slash)
Then I need to add a file extension (.jpg) after the numbers from cell A1.

So, C1 needs to = A1 + productimages/(cell a1+.jpg)
Final C1 looks like: productimages/64001005.jpg

Any help would be greatly appreciated.
Thanks!
 
C

CLR

In A1 put 64001005
In B1 put productimages/
In C1 put =B1&A1&".jpg"

Vaya con Dios,
Chuck, CABGx3
 
G

Guest

Thanks for viewing my need, but I figured it out. I used the =CONCATENATE
formula. Saved me tons of time.
 
C

CLR

Thats great!.........many times, "expressing your need", identifies the
direction of the solution..........
Glad you figured it out yourself........

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top