Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nees Function to Split
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nees Function to Split
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 ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nees Function to Split
Use DataText to Columns
Regards, Fred "ytayta555" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nees Function to Split
It works how I need ,
Thank you very much . Have a good evening |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split Cell using If or other function | Excel Worksheet Functions | |||
What are the main benifits of using the Split function? | Excel Worksheet Functions | |||
How can I keep sheet tabs visible when I use split pane function? | Excel Discussion (Misc queries) | |||
Split Cells using a Function | Excel Worksheet Functions | |||
Split into 2 wrkshts, now function doesn't work | Excel Worksheet Functions |