tags:

views:

11

answers:

1

Hi,

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?

+1  A: 

Shouldn't

="../dir/dir2/dir3" & A1

Work?

Noon Silk
Chris