Hello. I have this in a cell Y:\Financial Analyst\Customer Satisfaction\CustSat - Copy\Datafile 2009_MAY.xls
How could I create a formula that would allow me to drag that text down and change ONLY the date part? So, the second row would end with 2009_June, the next row with 2009_July etc.
Bookmarks