i have one excel which contains description like
“NEFT CR-KKBK0958-BHARAT FINAL LIMITED-BJ ALNZ LIFE INSNCE CO LTD-KKBKH191257”
i want to remove BHARAT FINAL LIMITED-BJ ALNZ LIFE INSNCE CO LTD
output is like NEFT CR-KKBK0958-KKBKH191257
here share u my exceltest.xlsx (9.4 KB)
try this XAML
Sting Split.xaml (5.0 KB)
as i had only one test case i have made a regex hope it helps.
if you face any problems you can get back anytime.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.