Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Can someone tell me how I can make the following output?

I have a cell with a number for example:

  • 12345 (a1)

I have a path to a file:

  • ../dir/dir2/dir3

and a file extension called .jpg

I need a output in f3 like this

../dir/dir2/dir3/12345.jpg

I tried a lot of stuff like:

../dir/dir2/dir3+A1 (I know, I can't count text and numbers)

So I tried the following

../dir/dir2/dir3&A1

But nothing seems to work

Can anyone tell me how to do this?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Use the CONCATENATE function:

=CONCATENATE("../dir/dir2/dir3/",A1,".jpg")
share|improve this answer
    
Commas between the items, not semi-colons. Nice answer, you beat me to it :) –  Jared Harley Feb 28 '10 at 22:30
1  
I have to put semi-colons. Maybe because of my regional settings (French). –  Snark Feb 28 '10 at 22:38
    
Great help, thanks! –  Chris Feb 28 '10 at 23:36
    
interesting, that may be. I tried yours and got an error telling me it had to be commas :) –  Jared Harley Mar 1 '10 at 0:30
    
My regional settings are Turkish and I have to use semi-colons like Snark does. –  Mehper C. Palavuzlar Mar 1 '10 at 9:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.