Dear sir
I have set of data in that column D:D contains vendor ids start with T or end with 1 in some cases
i want remove Where ever start with "T" and remove 1
TMTT AND MTT I WANT TMTT AS MTT
MCS1 AND MCS I WANT MCS1 AS MCS...
find the attachment
Bookmarks