Hello Mappers!

I have a street address column that looks as follows

2 23 Smith Street

and

33 4 Jones Street

The problem I have is that I want to be able to remove the space between
the numbers....have been looking at instring and mid$ but cant see how
they will help....

any ideas

TIA


begin:vcard 
n:Carlsson;Steve
tel;fax:9328 2716
tel;work:9328 2715
x-mozilla-html:FALSE
org:Desktop Mapping Systems
version:2.1
email;internet:[EMAIL PROTECTED]
title:Training and Support Manager
adr;quoted-printable:;;1/646 Newcastle Street=0D=0ALEEDERVILLE;PERTH;Western Australia;6007;
x-mozilla-cpt:;23600
fn:Steve Carlsson
end:vcard

Reply via email to