Excel Alignment Right and Replace

hello guys,
i have one excel which contains mobile no and also some Word/Characters(“DCM”) need to find out Characters and then keep that empty.i tried but keeping empty not working for me.will share u my excel. output should like sheet2.data.xlsx (11.7 KB) .Want to remove “DCM” and keep Empty

@sayli

PFA Main.xaml (8.2 KB)

3 Likes

Thanks Dear

1 Like

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

Hi ,
Here is an activity called “Find Replace”. using this activity you can replace the DCM by empty.

Regards
Balamurugan.S

1 Like