I have a large number of spreadsheets that are saved each month in a
particular directory. On each of the spreadsheets I would like the name of
the month to display. I believe the formula is =Mid(€œfilename€�) to extract
the name from the filepath etc, but I cannot figure out how to automatically
make the whole name of the month appear. I know that the actual month starts
at character 85 and that immediately after the name of the month there is a
€œ\€�. Is it possible give the information above for someone to help? TIA

Chris can you post your entire file name?

"Chris waller" wrote:

I have a large number of spreadsheets that are saved each month in a
particular directory. On each of the spreadsheets I would like the name of
the month to display. I believe the formula is =Mid(€œfilename€�) to extract
the name from the filepath etc, but I cannot figure out how to automatically
make the whole name of the month appear. I know that the actual month starts
at character 85 and that immediately after the name of the month there is a
€œ\€�. Is it possible give the information above for someone to help? TIA

Perhaps

=MID(S,85,FIND("\",S,85)-85)

Where S is the string containing the file information.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Fri, 13 Feb 2009 10:57:20 -0800, Chris waller
wrote:

I have a large number of spreadsheets that are saved each month in a
particular directory. On each of the spreadsheets I would like the name of
the month to display. I believe the formula is =Mid(“filename”) to extract
the name from the filepath etc, but I cannot figure out how to automatically
make the whole name of the month appear. I know that the actual month starts
at character 85 and that immediately after the name of the month there is a
“\”. Is it possible give the information above for someone to help? TIA

Sandy,

I cannot post the full name as it is at work and I will not be there until
Monday, but I will try to remember and post it on Monday evening.

"Sandy" wrote:

Chris can you post your entire file name?

"Chris waller" wrote:

I have a large number of spreadsheets that are saved each month in a
particular directory. On each of the spreadsheets I would like the name of
the month to display. I believe the formula is =Mid(€œfilename€�) to extract
the name from the filepath etc, but I cannot figure out how to automatically
make the whole name of the month appear. I know that the actual month starts
at character 85 and that immediately after the name of the month there is a
€œ\€�. Is it possible give the information above for someone to help? TIA

Chip,

Thanks for that. I will give it a go on Monday. Thanks once again.

"Chip Pearson" wrote:


Perhaps

=MID(S,85,FIND("\",S,85)-85)

Where S is the string containing the file information.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Fri, 13 Feb 2009 10:57:20 -0800, Chris waller
wrote:

I have a large number of spreadsheets that are saved each month in a
particular directory. On each of the spreadsheets I would like the name of
the month to display. I believe the formula is =Mid(€œfilename€�) to extract
the name from the filepath etc, but I cannot figure out how to automatically
make the whole name of the month appear. I know that the actual month starts
at character 85 and that immediately after the name of the month there is a
€œ\€�. Is it possible give the information above for someone to help? TIA