Parsing string to multiple columns

G

Guest

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.
 
R

Ron Rosenfeld

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.
Click to expand...

Select A1:An

Select Data/Text to Columns
Delimited
Next
Select Other and type a PERIOD (.) in the box
Finish
--ron
 
Top