cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samilibbab
Frequent Visitor

Extract custom text from the column

Hello everyone!

 

I have tried using delimiters, match, search and find but could not figure out how to extract the information from column A. 

 

Please review the below table.

 

The final result is shown in columns b, c and d. 

 

spent an entire week trying to figure it out; any help is much appreciated.

 

Column A, the Description contains information on property area m2, sqm and price per annum/Year/p a. I would like to extract the values from column A to respective columns.

 

 

 

DescriptionArea m2sqm$ pa 
This rare opportunity in the heart of Wollongong with scope to capitalise or invest with current commercial operations in place. This site comprises of a huge mechanical shed 3.6m in height with an adjoining east facing residence offering a simplistic work from home/all on the one site option.
- Mechanical shed 3.6H x on concrete floor with lighting throughout
- Adjoining home complete with three bedrooms, one bathroom, full kitchen, living room, main bedroom with fireplace
- Each dwelling facing young street with own street frontage
- Footsteps to town, easy access to M1 motorway, 1.5 hours from Sydney CBD and 1km from Wollongong beaches
Council Rates
18 Young St: $6715.61 pa
  $6,715.61 
A location that needs no introduction combined with one of the most deceiving facades sits 111 Princes Highway Dapto. Larger than it appears externally, this 4 bedroom + study property sits as the first residential / commercial property passed the CBD. Offering the ideal location with endless possibilities the multi-use site is ready for the next generation!
The Main Features:
- 4 spacious bedrooms / consulting rooms plus study area
- 2 large living / reception areas off both entry points
- Large kitchen / lunchroom area
- Main bathroom with additional toilet in the internal laundry area
- Access down both sides of the property
- Front & rear yards with little maintenance required
- Large carport with side access for vehicles
The Real Benefits:
- R3 (medium density) zoned property
- Surrounded by loads of commercial property / opportunity
- 11m height limit – perfect for the future
- 1.2 : 1 FSR
- 16.3m frontage
The Important Numbers:
Property Size: 155sqm
Land Size: 523 sqm
Council Rates: $424.71 per quarter
Water Rates: $160.18 per quarter
 Property Size: 155sqm
Land Size: 523 sqm
  
Albion Park First National are pleased to offer a commercial space with professional office suites fully tenanted, Under Management which is situated on the ground floor for easy access
7 Offices spaces with high-speed internet service.
Board Room available for all tenants’ bookings via appointment.
Fully air conditioned to each room.
All rooms are private and fully operational.
Kitchen available for all tenants and bathroom.
Net takings are $ 84,162 Per year.
That’s a great 6.47 % return on your investment based on $1,300,000
Walking distance to the main shopping precinct and eateries.
Located in the main business and commercial hub.
Shellharbour City is the up and coming for both retail and commercial all within walking distance to each other.
This is a Blue-Chip investment with all tenants on leases and new clients waiting on vacancy’s
Outgoings Strata $7,596 per year
Council Rates $1,224 per year
Electricity $1348 per year
Water $1000 per year
NBN $439 per year, Cleaning $4,680 per year
  $ 84,162 Per year 
142 sqm Warehouse in total, comprising:
- 96 sqm of ground floor
- 46 sqm Mezzanine / office, with modern glass frontage
- Full shower, disabled WC and electric hand dryer
- Ground floor Kitchenette facility
- In addition 2 covered car parking spaces, as well as parking in front of the auto roller door
- NBN ready
- Fully secure gated complex
- Full drive around capability
- Bunnings on your doorstep, as well as the Northern Distributor.
- Being sold with vacant possession.
The Important Numbers:
Council Rates: $262.77pq
Water Rates: $161pq
Strata Levies: $946.49pq
*This advertising has been prepared by MMJ Real Estate (MMJ) for the purpose of advertising and general information only. MMJ do not guarantee, represent, or warrant that the information contained in this advertising is correct. Any interested party should undertake their own inquiries as to the accuracy of the information published.
 142 sqm Warehouse in total, comprising:
- 96 sqm of ground floor
- 46 sqm Mezzanine / office, with modern glass frontage
  
Located on the southern fringe of the Royal National Park, Helensburgh is an hour south of Sydney CBD and a 30 minute drive to Wollongong with the freeway interchange only 2km away.
An ideal prime street position with more development occurring now.
Key highlights include:
• Zoned B2 Local Centre
• Land size 461.6m2 (7.6m x 60.9m) approx.
• Freestanding brick building measuring approx. 69m2
• Vehicle access and ample parking at the rear
Currently operating as a thriving butcher shop with happy tenants in a lease until December 2025 and an Option to Renew for further 5 years. A great investment.
For details of rental, outgoings etc. please contact Julie York for an Information Sheet.
Freestanding brick building measuring approx. 69m2  
1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @Samilibbab,

 

Please see attached pbix for your reference.

 

Here is the snippet of the result  made.

Just for the last row description, area m2, why the land size is not included on your extraction?

In case you don't need the land size infor, 

just adjust the condition on extracting the text.

mussaenda_0-1670216837182.png

 

Hope this  helps

 

View solution in original post

2 REPLIES 2
Samilibbab
Frequent Visitor

Thank you very much. 😁

mussaenda
Super User
Super User

Hi @Samilibbab,

 

Please see attached pbix for your reference.

 

Here is the snippet of the result  made.

Just for the last row description, area m2, why the land size is not included on your extraction?

In case you don't need the land size infor, 

just adjust the condition on extracting the text.

mussaenda_0-1670216837182.png

 

Hope this  helps

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors