| 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 [TABLE="width: 435"] <colgroup><col></colgroup><tbody>[TR] [TD]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 style="mso-width-source:userset;mso-width-alt:15908;width:326pt" width="435"> </colgroup><tbody>
[TD="width: 435"]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
[/TD]
</tbody>
[/TR]
</tbody>[/TABLE]
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.
