Excel Professional Formula Writing
I have a cell for full names
I would like to replace/remove the following characters from the whole
excel sheet:-
Al- OR Al OR EL
But the fact is I want them to be replaced only IF the word start with
that characters them for instance:-
Alorfze
NOT: arALfzi
Moreover, It will only replace this characters if the matched word has
more than 4 characters
Could anyone help with this please?
No comments:
Post a Comment