donlincolnmre
New Member
- Joined
- Jun 11, 2005
- Messages
- 46
Hello
I'm trying to split the numeric portion of the address in 1 column and the rest into another colum, the TEXT TO COLUMN fuction will break up in to severl difference weired coulmne, i just need to split this in to 2 colum.
c coulmn should have just the numeric portion of the addresss &
d should have the rest of the address.
Any help would be appreciated.
here is the code.
I'm trying to split the numeric portion of the address in 1 column and the rest into another colum, the TEXT TO COLUMN fuction will break up in to severl difference weired coulmne, i just need to split this in to 2 colum.
c coulmn should have just the numeric portion of the addresss &
d should have the rest of the address.
Any help would be appreciated.
here is the code.
Book4 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 15326 Binney St | |||||
2 | 13823 Vista Grande Dr | |||||
3 | 2341 Silk Tree Dr | |||||
4 | 8238 Noren St | |||||
5 | 5035 Vista Montana | |||||
6 | 19762 Hi Top Ln | |||||
7 | 525 S Westgate Dr | |||||
8 | 4932 Park Pl | |||||
9 | 7364 Cerritos Ave | |||||
10 | 5730 Southview Dr | |||||
11 | 5510 Westfield St | |||||
12 | 29 Alegria | |||||
13 | 12 Heritage | |||||
14 | 121 S Grand Ave | |||||
15 | 4539 N COLDBROOK | |||||
16 | 3764 Bella Isola Ln | |||||
17 | 5007 N peck Rd B | |||||
18 | 41126 Academy Dr | |||||
19 | 4492 CHEVIOT | |||||
20 | 1600 Skyline Dr | |||||
21 | 1320 Sheller Dr | |||||
22 | 3248 Ashgate Ct | |||||
23 | 43138 Corte Argento | |||||
24 | 480 S Lyon Ave | |||||
25 | 24 Charlotte | |||||
26 | 10908 Newville Ave | |||||
27 | 506 Terra Bella | |||||
28 | 6586 Valley Dr | |||||
29 | 5427 Ashworth St | |||||
30 | 14646 Willow Leaf Rd | |||||
Sheet1 |