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
<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.