View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
miki peric miki peric is offline
external usenet poster
 
Posts: 1
Default 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