creating a filename based on the cells

**jherhung** · 06-01-2009, 11:15 AM

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

=A:A&"_"&E:E&"_TraceView_"&H:H&".txt"

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** · 06-01-2009, 08:15 PM

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:

=A2&"_"&E2&"_TraceView_"&TEXT(H2,"yyyymmdd_hhmmssAM/PM"&".txt")

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** · 06-02-2009, 07:02 AM

wow..thanks!!

creating a filename based on the cells

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

creating a filename based on the cells

Re: creating a filename based on the cells

Re: creating a filename based on the cells

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions