HI, I have a variable name which contains DR JAMES KINDY MISS JUME ALFINE MA JOSEPH ABRAM LINKCON HAROID KINDERSON GEORGE From the abvoe line i want to remove only DR,MISS , MA and create a new Variable with Full name except the designations. like below: JAMES KINDY JUME ALFINE JOSEPH ABRAM LINKCON HAROID KINDERSON GEORGE If I apply tranwrd fuction it will remove only last value called "MA" not other two values, also in the same value where ever MA is it is removing from String value. any best solution
... View more