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?


Use the CONCATENATE function:

  • 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
  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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