How to remove specific text in particular column in cell value

[Raja.G (Mr.RPABot)]

Hi Team,

I want to remove particular data from in particular column(Name), I couldn’t able to remove so please anyone help me for this.

Remove data Rggg , Mhhh, iiiii
I need to only name in name column(ARUN KUMAR, GANESH KANNAN, AJITH KUMAR)

Input:

Expected Output:

Regads,
Raja G

[loveleet_Saini]

@Raja.G

Rggg , Mhhh, iiiii

Hi @Raja.G

Below Solution may help you.

FilterCellVAlue.xaml (8.4 KB)
o

Regards
Loveleet Saini

[Raja.G (Mr.RPABot)]

Hi @loveleet_Saini ,

Thank you for solution , i have another question that string space are longspace i couldn’t get name please help me this.

Sorrry to ask again

Regards,
Raja G