Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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


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


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:

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


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.