Hi all!
just wondering if its possible at all to list multiple date ranges from 1 cell into multiple rows in the same column? i think want to run a lookup for the date ranges vs the season rates to automatically complete into a template i have for data uploading. example as per below.
Season 1 21Jan13-31Feb13; 01mar13-02mar14; 03mar14-24mar14
Season 2 again multiple date ranges separated by ;
Season 3 again multiple date ranges separated by ;
Season 4 again multiple date ranges separated by ;
This is how I want the season 1 ranges to paste into excel - separate cells
21Jan13 31Feb13
01Mar13 02Mar14
03Mar14 24Mar14
Tried to ScreenShot - didnt want to upload though
Appreciate any help guys! thanks!
Bookmarks