How do I Remove the Digit And hyphen from the Excel Datatable?

image
I have attchaed the SS for better understanding

I want only Book, Class and so on wan to remove Digit and Hyphen Prefix.

Hi @kishan.savaliya

You can do it by data manipulation(Substring method, split method etc)

1 Like

@kishan.savaliya Use below expression.
CurrentRow(“Name”).ToString.Trim.Split("-"c)(1)

1 Like

@kishan.savaliya
testt.xaml (7.8 KB)

1 Like

Hi @kishan.savaliya,

Cheers,
Kiran T

1 Like

Thanks all of you for Solution @tkiran @jack.chan @sb001 @loveleet_Saini

1 Like

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