Extracting amount from a string using regex

[Erine6726]

Hi, can anyone help to provide solutions to extract the amount in Input column? My painpoint here is that the amount is not only in numeric format but can also be in string and special characters. Thanks

Input	Output
Interim dividend of 2.5 sen per share	2.5 sen
Special Single Tier Interim Dividend of RM0.006 per ordinary share	RM0.006
First and Final Single-Tier Dividend of three (3) sen per ordinary share	(3) sen
Interim Single Tier Dividend of one sen per ordinary share in respect of the financial year ending 31 May 2024	one sen
Dividend of 5.72 sen per share on the 1,284,000,000 ordinary shares, amounting to RM73.444 million in respect of the financial year ending 31 Dec-23	5.72 sen

[caltang · Accepted solution]

Like so:

[Erine6726]

Thanks for your swift response!