anilg0001
06-05-2013, 11:41 PM
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
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