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.

On Sun, 3 Jun 2007 17:54:00 -0700, Goujon
wrote:

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.

Select A1:An

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

Thanks Ron, that's what I wanted. You saved me a lot of time!

"Ron Rosenfeld" wrote:

On Sun, 3 Jun 2007 17:54:00 -0700, Goujon
wrote:

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.

Select A1:An

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

On Sun, 3 Jun 2007 18:50:00 -0700, Goujon
wrote:

Thanks Ron, that's what I wanted. You saved me a lot of time!

You're welcome. Glad to hear that it worked for you.
--ron