Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .