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,

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,“[1]+|[A-z]+$”)(0).ToString+" “+System.Text.RegularExpressions.Regex.Matches(row(“Department”).ToString.Trim,”[2]+|[A-z]+$")(1).ToString
Can you please explain me this statement

  1. A-z ↩︎

  2. A-z ↩︎

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