How to de-concatenate mailing address similar to text to column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please advise if you know how to do this in Access similar to what I am doing
in Excel's text to columns but it taking a long time. Thanks!
 
To de-cat, there must be some kind of logical break. Included in that word
logical is the word consistent, of which addresses are not.

The tools to break apart strings are:

Left()
Right()
Mid()
Instr()
InStrRev()
Replace()

Like any other toolbox, some of these tools are hammners, and others are
Inside Micrometers, so visit the help file for info on each.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
 
Back
Top