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

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