Hi Everyone,
Can I please have a formula to extract numbers from alphanumeric string. I just need the four numbers in between the texts. They are separated by /. A sample data with desired output is given below.
[TABLE="width: 248"]
[TD="width: 330, bgcolor: transparent"]WV R&TConst40/15BathroomRenov-Labour[/TD]
[TD="bgcolor: transparent"]FC33027 KMSCon 05/16 1 x Aircon Labour[/TD]
[TD="bgcolor: transparent"]FC29382OzeCool06/16ColdroomMotorLabour[/TD]
[/TABLE]
[TABLE="width: 330"]
Desired Output
40/15
05/16
06/16
Thank you so much in advance
Kaavya
[/TABLE]
[/TD]
[/TR]
[/TABLE]