Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
parsing a string | Excel Programming | |||
Parsing a string | Excel Programming | |||
Parsing a string | Excel Programming | |||
Need help parsing a string | Excel Programming | |||
parsing a string | Excel Programming |