need an excel macro for split from last space

[anilg0001]

if my F range has
1935 E Bijou St 80909-5816
3030 N Hancock Ave 80907-5761
5490 Powers Center Pt. #148 80908

i need to split from last space

F range a
1935 E Bijou St
3030 N Hancock Ave
5490 Powers Center Pt. #148
G range as
80909-5816
80907-5761
80908

need a macro not equation

[:) Sixthsense :)]

In A1 Cell
1935 E Bijou St 80909-5816

In B1 Cell

Please Login or Register  to view this content.

Drag it down..

[anilg0001]

sorry mr sixthsence
i need a macro not formula that i specified in #1

[:) Sixthsense :)]

Try this code...

Change the Range("A1:A5") to your desired range...

Please Login or Register  to view this content.

[anilg0001]

while running this macro two problems comes
1. all spaces are removed (F range)
2. last word did not come in next cell (G range)

[jindon]

Try this

Please Login or Register  to view this content.

[anilg0001]

thank u mr jindon

[:) Sixthsense :)]

Try this revised code....

Please Login or Register  to view this content.