View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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