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

Give this formula a try...

=MID(LEFT(A1,FIND("\",A1,85)-1),85,9)

--
Rick (MVP - Excel)


"Chris waller" wrote in message
...
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