I have a column that looks like this:
| Site Name |
| Abbotsford 4 Harper St - DELWP |
| Alfredton-8 Michaels Dr |
| Bairnsdale 535 Princes Hwy |
| Bairnsdale 574 Main St |
| Bairnsdale 7 Service St - DHHS |
| Ballarat 109 Armstrong St - DET |
| Ballarat 111 Armstrong St - DEDJTR |
| Ballarat 206-208 Mair St - DOJR |
| Bendigo Cnr Queen & Edward St - DHHS |
| Bendigo-57 Lansell St |
| Bendigo-71 Bridge St |
| Box Hill 703 Station St - DOJR |
| Broadmeadows 25-27 Dimboola Rd - DOJR |
| Broadmeadows 56 Coleraine St |
| Broadmeadows Cnr Pearcedale & Johnstone |
| Bundoora 20 Enterprise Dve - DEDJTR |
| Bundoora 8 Graduate Rd - VR |
| Burwood East 12 Lakeside Dve - VR |
| Carlton 459 Lygon St |
| Cheltenham 4-10 Jamieson St - DHHS |
| GEELONG WEST-59-63 SPRING ST |
I want it to be formatted as:
| Site Name | Denomination |
| Abbotsford 4 Harper St | DELWP |
| Alfredton-8 Michaels Dr | |
| Bairnsdale 535 Princes Hwy | |
| Bairnsdale 574 Main St | |
| Bairnsdale 7 Service St | DHHS |
| Ballarat 109 Armstrong St | DET |
| Ballarat 111 Armstrong St | DEDJTR |
| Ballarat 206-208 Mair St | DOJR |
| Bendigo Cnr Queen & Edward St | DHHS |
| Bendigo-57 Lansell St | |
| Bendigo-71 Bridge St | |
| Box Hill 703 Station St | DOJR |
| Broadmeadows 25-27 Dimboola Rd | DOJR |
| Broadmeadows 56 Coleraine St | |
| Broadmeadows Cnr Pearcedale & Johnstone | |
| Bundoora 20 Enterprise Dve | DEDJTR |
| Bundoora 8 Graduate Rd | VR |
| Burwood East 12 Lakeside Dve | VR |
| Carlton 459 Lygon St | |
| Cheltenham 4-10 Jamieson St | DHHS |
| Geelong West-59-63 Spring St | ST |
The actions to be performed:
Regex Split with delimiter as '-' before the last text
Change case to title case
I am really weak in regex hence, requesting help.
Thanks.
