How to remove specific text in particular column in cell value

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:
image

Expected Output:
image

Regads,
Raja G

Hi @Raja.G

Below Solution may help you.

FilterCellVAlue.xaml (8.4 KB)
o

Regards
Loveleet Saini

1 Like

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

image

Regards,
Raja G

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.