Apt number after street address

**pick44** · 01-11-2019, 04:42 PM

Large database with the Address in Column F , beginning with F2 and some have apt numbers after the address. Need to remove that. The apt numbers could be 1 number or up to 5 numbers. See attached sample. Using windows 10 and excel 2016.

**TMS** · 01-11-2019, 05:10 PM

This copes with "normal" numbers at the end, though it does not handle numbers with leading zeroes, for example, 0204.

Formula:

Please Login or Register  to view this content.

This will handle the 0204 scenario but it is a little longer ...

Formula:

Please Login or Register  to view this content.

**pick44** · 01-11-2019, 05:48 PM

Yes, it worked perfectly. Thank you

**TMS** · 01-11-2019, 05:54 PM

You're welcome.

Apt number after street address

LinkBack

Thread Tools

Rate This Thread

Display

Apt number after street address

Re: Apt number after street address

Re: Apt number after street address

Re: Apt number after street address

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] i need to parse a numeric value from a text string (like house number from street address)

Look up specific street address within street address range

[SOLVED] Extracting street name and house number from address list

Extract House Number from Street Address into new Cell

separate street address and street number

extract street number from address

Help!! sort address field by street, then number??

Bookmarks

Bookmarks

Posting Permissions