Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting numbers
Hi, I need help with splitting numbers. I got the numbers in excel in each cell like this:
A1: 0000 02 1.884308 A2: 6 02 1.092346 ...... and need to put each number in a cell like: A1: 0000 B1:02 C1: 1.884308 A2: 6 B2:02 C2: 1.092346 if someone can help me it would be great because i have a lots of data to split in three columns. thanks EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting numbers
On Mon, 05 Jan 2009 15:56:45 -0800, miki peric wrote:
A1: 0000 02 1.884308 A2: 6 02 1.092346 Try using "Text to Columns" and specify that your data are delimited by Space and Treat consecutive delimiters as one. Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting numbers
On Tue, 06 Jan 2009 00:01:58 GMT, Lars-Åke Aspelin
wrote: On Mon, 05 Jan 2009 15:56:45 -0800, miki peric wrote: A1: 0000 02 1.884308 A2: 6 02 1.092346 Try using "Text to Columns" and specify that your data are delimited by Space and Treat consecutive delimiters as one. Hope this helps / Lars-Åke And here comes a link to a description on how to do it http://www.worldstart.com/tips/tips.php/1153 Lars-Åke |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting numbers
On Mon, 05 Jan 2009 15:56:45 -0800, miki peric wrote:
Hi, I need help with splitting numbers. I got the numbers in excel in each cell like this: A1: 0000 02 1.884308 A2: 6 02 1.092346 ..... and need to put each number in a cell like: A1: 0000 B1:02 C1: 1.884308 A2: 6 B2:02 C2: 1.092346 if someone can help me it would be great because i have a lots of data to split in three columns. thanks EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com Select A1:A2 Select Data/Text-to-columns Delimited Next Space Treat Consecutive Delimiters as one Next Column Data Format For Columns 1 & 2, select TEXT Finish --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting complex string into 3 numbers with a formula - Please help! | Excel Worksheet Functions | |||
Splitting column with text & numbers | Excel Discussion (Misc queries) | |||
Splitting Numbers | Excel Discussion (Misc queries) | |||
Splitting item numbers | Excel Discussion (Misc queries) | |||
Splitting Numbers Into Different Columns | Excel Discussion (Misc queries) |