Prev: cell range not changing when refreshing linked data sumproduct fo
Next: Formula for adding time
From: ytayta555 on 25 Feb 2010 15:05 Hi All I have in one cell some numbers , separated with commas . Eg : 1, 22, 24, 44, 56, 77 After every number follow a comma , and then is a space till to the next number . I need a function / formula to put every number separate in the next right cells : A1: 1, 22, 24, 44, 56, 77 B1: 1 C1: 22 D1: 24 E1: 44 ... etc Thank you in advance
From: Bernard Liengme on 25 Feb 2010 15:35 You do not need formula. Select the cell (or cells) and use Data  Text to Column, specify Delimited and check comma and space. best wishes  Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "ytayta555" <wherewindsmeet(a)gmail.com> wrote in message news:e4de8d4ac3f444acaa9ab2a094ed87b4(a)m37g2000yqf.googlegroups.com... > Hi All > > I have in one cell some numbers , separated with > commas . Eg : > > 1, 22, 24, 44, 56, 77 > > After every number follow a comma , and then is a space > till to the next number . I need a function / formula to put > every number separate in the next right cells : > > A1: 1, 22, 24, 44, 56, 77 B1: 1 C1: 22 D1: 24 E1: 44 ... > etc > > Thank you in advance
From: Fred Smith on 25 Feb 2010 15:38 Use Data>Text to Columns Regards, Fred "ytayta555" <wherewindsmeet(a)gmail.com> wrote in message news:e4de8d4ac3f444acaa9ab2a094ed87b4(a)m37g2000yqf.googlegroups.com... > Hi All > > I have in one cell some numbers , separated with > commas . Eg : > > 1, 22, 24, 44, 56, 77 > > After every number follow a comma , and then is a space > till to the next number . I need a function / formula to put > every number separate in the next right cells : > > A1: 1, 22, 24, 44, 56, 77 B1: 1 C1: 22 D1: 24 E1: 44 ... > etc > > Thank you in advance
From: ytayta555 on 25 Feb 2010 15:45 It works how I need , Thank you very much . Have a good evening

Pages: 1 Prev: cell range not changing when refreshing linked data sumproduct fo Next: Formula for adding time 