How to delete Middle word and word which is present after that one in Excel Cell?

Rough Data.xlsx (8.7 KB)
I want to delete text in Department Column i.e I need to delete middle text in every row of that column, i.e “Science and” in Computer Science and Engg , “and Communication” in Electronics and Communication Engg. Likewise I want to do in each row of Department Column.So, please suggest me how to do or provide any workflow if you have…
Thanks & Regards,
Kavya.

You can use split string and string concatenate.
Please see the posts below:-
1)How to Split a String
2)Concatenating strings and variables

1 Like


I want to get the output like this…Can you please send me any sample workflow

Check this below wokflow @Kavyasri
Excel_Changes.xaml (6.1 KB)
Check the output file attached here with different sheet name Rough Data.xlsx (10.0 KB)
Hope this may help you :slight_smile:

1 Like

Its working.Thank you so much :slightly_smiling_face: @Manish540
System.Text.RegularExpressions.Regex.Matches(row(“Department”).ToString.Trim,"^[A-z]+|[A-z]+")(0).ToString+" "+System.Text.RegularExpressions.Regex.Matches(row("Department").ToString.Trim,"^[A-z]+|[A-z]+")(1).ToString
Can you please explain me this statement

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