PDA

View Full Version : using a cell's text as part of a filepath in another cell



zest1
03-20-2006, 03:55 PM
can someone please tell me the proper syntax to use a cell reference for part of a file path in another cell? I can't seem to get it to work.

A2 = proj1

I'd like this:
C:\projects\["A2"&.xls]

mdmackillop
03-20-2006, 04:33 PM
="C:\Projects\" & A2 & ".xls"

zest1
03-21-2006, 09:18 AM
thanks