Need help in Excel

[Vikas_Salvi]

Need help with the formula in excel for the dry balcony area and open balcony/seat out area from the sentence.

for Example

Property Discription English	dry balcony area​	open balcony/seat out area​
1)Municipality Name: Pimpri-Chinchwad M.N.P. Other Description:, Other Information: Village Mauje Kiwale, Ta. Haveli, Dist. Pune Income Survey No. 87/B,88/4,88/10/1,88/10/2,88/11,88/16/1 and 88/17+18/1,Yansi combined area 13950 sq.m. Project S Abode Phase 2B Wing F to be built on this property, on the thirteenth floor flat no. 1301 Yasi Carpet Area 61.00 Sq. m., dry balcony area 1.22 sq.m., with open balcony/seat out area 3.92 sq.m. m., and with one covered car parking.( (survey number : 87 & 88; )​	1.22​	3.92​

Need the formula formula in excel for the same.

 

[pecoflyer]

Still not the slightest courtesy? You are now a select member of my "ignore" list.

 

[Peter Bartholomew]

If you have the latest versions of 365

= IFNA(REGEXEXTRACT(propertyDescription, regex), "")

where regex
= {"(?<=dry balcony area )[\d\.]+","(?<=open balcony/seat out area )[\d\.]+"}