Excel sheet data updation

I have an excel sheet with list of username as shown:
All entries have . and - succeeding the username. How can remove this dyamically as there are around 200 entries and It isn’t easy to manually remove.

Hi Gopalakrishnan_K,

Please try below code:
Use Assign Acitivity

Find below attached workflow below

(upload://d5gz6wmT6nxWFsNYOWQoEfNK7M1.xaml) (4.7 KB)

Hope this helps.


1 Like

check below workflow for References
ReplaceString.xaml (4.7 KB)

Hi @Gopalakrishnan_K,

If solution is working for you please mark it as solution.


1 Like

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