I have a spreadsheet I would like to upload with the column in question - how do I upload it?
On Oct 29, 7:19 pm, Dave Bonallack <[EMAIL PROTECTED]> wrote: > 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. > > _________________________________________________________________- Hide > quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
