Excel extract specific set of words from a Column

[Pratik_Wavhal]

Hi @Apple1

Below is the working String Manipulation for the same along with regex :-

Regex.Replace(row(0).ToString.Trim,"\s+"," ").Split(" "c)(0)+Regex.Replace(row(0).ToString.Trim,"\s+"," ").Split(" "c)(1)

Below is the workflow for the same :-
MainPratik.xaml (9.7 KB)
Apple.xlsx (8.3 KB)

Output :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal