View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Goujon Goujon is offline
external usenet poster
 
Posts: 2
Default Parsing string to multiple columns

I have following set of data in Excel sheet:

Cell:Data (... - means the dtring is longer than depicted here)

A1: .91,200.3,000.0,050.0,000.0,000.4,900.0,000...
A2: .90,400.3,000.1,000.0,700.3,000.4,000.0,000...
An: 34 decimal numbers in a row, delimited by PERIOD (I can apply any
charaсter).

I need a macros or easy procedure to parse abovemetioned strings set into
following representation:

B C D E F G H ...
1: 91,200 3,000 0,050 0,000 0,000 4,900 0,000 ...
2: 90,400 3,000 1,000 0,700 3,000 4,000 0,000 ...
n: 34 decimal numbers each in its own cell column.

Please help me do that. I'm stuck... I know VBA not so well, so working
macros or complete code would be appreciated. Thanks in advance.