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

jamada

Active Member
Joined
Mar 23, 2006
Messages
323
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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

TheNoocH

Well-known Member
Joined
Oct 6, 2004
Messages
3,482
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

Active Member
Joined
Mar 23, 2006
Messages
323
If you could only see the smile on my face!..........Oh How easy that was!

Thanks a million

g
 

Forum statistics

Threads
1,136,708
Messages
5,677,317
Members
419,687
Latest member
ash59

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top