Re: MI remove street names from address

2000-04-09 Thread Mick
n with a formula in, teh final columnn should have the required answe hope this helps PS what are you doing working on Saturday Mick - Original Message - From: Dave Lagerstedt [EMAIL PROTECTED] To: mapinfo-l [EMAIL PROTECTED] Sent: Saturday, April 08, 2000 3:25 PM Subject: MI remove

MI remove street names from address

2000-04-08 Thread Dave Lagerstedt
I have a table with a column of street addresses such as 14963 140th St. I want to remove the 140th St portion and be left with just 14963 in either that column or another column. Can this be done in Mapinfo or Excel? If so how? Thank you Dave Lagerstedt