Extract and Remove Level #, Unit #, in address Address

Winter01

New Member
Joined
Jul 23, 2018
Messages
1
Hi All,

I am just a beginner in Excel If some can assist me in extracting Level #, Unit #, in the sample table below?
it would be a great help for me


DATA: Column A

Level 2 142 North Terrace
Level 1 / 238 Angas Street
Level 1/ 46 Sir Donald Bradman Drive
182-190 Wakefield Street 1st Level
Harmer House - Level 2, 5 Leigh St
Level 14 Anz House
Level 3 / 300 Flinders Street
Level 3
Level 1 / 50 Grenfell Street
Level 3/68 Grenfell St
Level 10
Level 5 / 55 Gawler Place
111A Balcany Level/ Adelaide Arc
Level 2, 169 Pirie Street
Level 1
Level 1
Level 3 / 104 Frome Street
Level 11/ 30 Wakefield Street
Level 1/45 Wakefield Street
Level 5, 33 Franklin Street
Level 3, 117 King William Street
SUITE 3, LEVEL 1, 57-59 UNLEY RD
Level 2 / 272 Flinders St

<colgroup><col></colgroup><tbody>
</tbody>

<colgroup><col style="mso-width-source:userset;mso-width-alt:15908;width:326pt" width="435"> </colgroup><tbody>
</tbody>


Result: Column B


Example:

Column A

SUITE 3, LEVEL 1, 57-59 UNLEY RD


Column B

Level 1

Column C:

Suite 3



If its in the thread please send the link

thank you.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,215,388
Messages
6,124,641
Members
449,177
Latest member
Sousanna Aristiadou

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top