creating a filename based on the cells

[jherhung]

I’m a newbee. A little help needed here..
I have a table soalan.xls. From the table, I want to link a txt file directly from a cell.
I’ve figured out how to do the linking but the problem is to create the name of the file.The file name should be like this.

PBQ2TNH_ER_SETUP_TraceView_20090601_083520AM.txt

The name file generated is based on the column A,E and H.

I used a formula

Please Login or Register  to view this content.

at column O because I want the filename to be there.

The name I got is PBQ2TNH_ER_Setup_Test_TraceView_39965.3578703704.txt

Can u help me solve this? Please let me know if the data is not enough.

[mdbct]

Excel stores date/times as a number. When you concatenate fields you need to tell your formula how to format that number, otherwise Excel returns the numerical representation of the date.

The formula in O2 would be:

Please Login or Register  to view this content.

Sidebar-You should not reference the entire column in your formula (the A:A, E:E, and H:H), you should only refer to the cells you need to work with.

[jherhung]

wow..thanks!!