+ Reply to Thread
Results 1 to 2 of 2

Removing unit numbers from addresses

  1. #1
    Registered User
    Join Date
    09-08-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unhappy Removing unit numbers from addresses

    Hi,

    I hope someone can help, I need to be able to trim a list of address I have in say column A, so that any unit numbers, or levels are removed and am left with just the building number and street name, and have this returned into another column.

    Examples:
    lvl 24 105 example st ----> 105 example st
    unit 12, lot 5 example rd ---> 5 example rd
    4/33 example ave ----> 33 example ave
    123 example st ----> 123 example st

    I've tried functions like RIGHT, ISNUMBER and MATCH to try and have it search from the right to the nearest number and then return everything to the right, but haven't succeeded.

    Any help is appreciated.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Removing unit numbers from addresses

    Hi tarentagore
    Welcome to the forum
    try using ...
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1