Hi, I need help with a spreadsheet. The spreadsheet is created using a program I have no control over. I have a column that can contain weeks that a course is run. It seems to come out in the following formats:
Weeks 10 - 12 8 6, 11 - 12 4 - 6, 8 - 10 3 - 7, 11 I want to split each and have a comprehensive list of the weeks. I want it to look like this: 10 11 12 8 6 11 12 4 5 6 8 9 10 3 4 5 6 7 11 But I have thousands of rows and do not want to do it manually. I have tried using text to columns in many different ways and was able to get: 10 12 8 6 11 12 4 6 8 10 3 7 11 But this does not help. You don't know now if the first one was 10 and 12 or 10 through 12. Can anyone help? I have a nifty macro to count up the final number of weeks and insert that many rows underneath to have a line for each week the course but I just can't work out an automatic way to get all the course weeks in separate cells. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
