Hi, We need to know how the current data appears in the cells. for example, 10 - 12 Is that 10 in column A, - in Column B, and 12 in Column C? or the whole lot in one cell? Perhaps if you attach a file with some sample data, it would be helpful. Regards - Dave.
> Date: Tue, 28 Oct 2008 21:12:24 -0700 > Subject: $$Excel-Macros$$ Number ranges in a cell > From: [EMAIL PROTECTED] > To: excel-macros@googlegroups.com > > > 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 -~----------~----~----~----~------~----~------~--~---
