You need some way of identifying the position of the split. A common
character or type of characters such as spaces, numbers or specified number
of characters. Can you post a sample of 5 to 10 of the addresses. Rename the
Streets in your post to preserve privacy issues.

--
Regards,

OssieMac


"TotallyConfused" wrote:

I hope someone can help me with this. I have an address column. However,
this column has the main address and Suite ## or Bldg #. I need to separate
the main address and suite ## or bldge # so that the suite ## or Bldg ## is
in a separate column. How can I accomplish this as easy as possible? Thank
you in advance for any help you can provide.