Best way to remove ...

[hi2019]

Hi

Column 'ID CODES' needs to have these removed 

• suffixes II, III, IV, JR, SR for IND SUFFIX / MULT SUFFIX ID codes

Should a formula be the way to do this?

thanks

[KGT]

Either a long nested replace(replace(replace.... or a Find/Replace tool linked to a lookup table (text input) with these values in it. Make sure you choose "Beginning of Field".

[flying008]

Hi, @hi2019 

Could you upload some sample data for input and output ?