VBA Help! If a line of text contains a blank then

[jamada]

If a line of text contains a blank then enter the text following the blank in the next column, fo rexample, the following pasted as is into excel would eneter all text in Column A, and subsequent rows.

This is How I would like to see it for example (except there would be many rows)

  A     B        C  D      E     
1 2-Oct  11:04   54 30,000 0.125 

Sheet1
[Table-It] version 06 by Erik Van Geit




10-02 11:04 54 30,000 0.125
10-02 12:44 7 50,000 0.125
10-02 12:57 7 25,000 0.125
09-28 11:10 7 30,000 0.12
09-28 15:58 54 30,000 0.12
09-29 10:36 80 14,000 0.12
09-29 13:25 2 4,000 0.12
09-29 15:23 83 40,000 0.12
A 10-02 08:15 79 4,000 0.12
10-02 11:05 7 20,000 0.12
09-22 08:36 85 10,000 0.115
09-27 14:26 1 60,000 0.115
09-27 14:31 80 20,000 0.115
A 10-02 09:53 2 20,000 0.115
07-10 08:05 7 10,000 0.11
09-19 14:17 7 20,000 0.11
09-21 09:48 7 30,000 0.11
09-27 10:09 54 20000 0.11
09-21 08:37 54 30,000 0.105
09-29 07:01 2 19,000 0.105
09-21 10:20 85 20,000 0.10
09-27 08:02 85 165,000 0.10
09-27 11:31 2 100,000 0.10
09-28 10:19 85 20,000 0.10
A 10-02 07:00 85 20,000 0.10
10-02 09:32 5 30,000 0.09
09-19 14:16 80 20,000 0.085
09-19 14:16 54 20,000 0.08
09-19 14:16 1 20,000 0.05

 

[TheNoocH]

you don't need VBA to do this...

try DATA text to columns and use delimited and SPACE as your delimiter


if you NEED or WANT a vba solution let me know...

 

[jamada]

If you could only see the smile on my face!..........Oh How easy that was!

Thanks a million

g