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" wrote in message news:e4de8d4a-c3f4-44ac-aa9a-b2a094ed87b4(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" wrote in message news:e4de8d4a-c3f4-44ac-aa9a-b2a094ed87b4(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  |