title: how to separate Unit/Suite/APT/# from an address in Excel
body: <p>I have a data base 272,000 addresses But some addresses have unit/suite/STE/APT seeexample below</p>
  
  <p>16 BRIARWOOD COURT UNIT B <strong>MONTVALE</strong>, NJ  07645 
  100 CROWN COURT #471 <strong>EDGEWATER</strong>, NJ  07020
  23-05 HIGH ST APT A <strong>FAIR LAWN</strong>, NJ  07410
  15-01 BROADWAY STE 6 <strong>FAIR LAWN</strong>, NJ  07410
  80 BROADWAY, SUITE 1A <strong>CRESSKILL</strong>, N.J.  07626
  300 GORGE ROAD APT 11 <strong>CLIFFSIDE PARK</strong>, N.J.  07010</p>
  
  <p>I would like to split the text to the next column when it comes across unit/suite/STE/APT</p>
  
  <p>I want to separate these so I can use Advance filter with unique records and create a master find and replace to clean the list....</p>
  
  <p>Any formulas I can use for this would be helpful....</p>