Excel Alignment Right and Replace

Help
1

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

2

@sayli

PFA Main.xaml (8.2 KB)

3 Likes
3

Thanks Dear

1 Like
4

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

5

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

Regards
Balamurugan.S

1 Like