Hello Keith_A_Lewis Henn Sarv PeterBartholomew1
Thank you all for the valuable contributions. I was not aware about that add-in and it's limitations as mentioned above, but not sure whether https://xlladdins.com/ has comprehensive support for full regex functionalities which is in-built in Python and further extended via library regex.
Anyway, good to know about that add-in. Hope it will be improvised further to tide over its' present limitations as above.
Update: I installed that add-in to test drive it - for knowing it's functionalities - but it fails to get activated when I start excel 365
(Microsoft 365 MSO (Version 2406 Build 16.0.17630.20000) 64-bit) - When I enabled that add-in and re-started excel, the message box appeared that "Add method of addins class failed".