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: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" <wherewindsmeet(a)gmail.com> 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
 | 
Pages: 1
Prev: cell range not changing when refreshing linked data- sumproduct fo
Next: Formula for adding time