Thanks guys for your answers, much appreciated. My project is a bit more complex. Actually ND means 'no data' and the suffix are just the different levels of missingness (not very important here though). So these variables will later be populated. here is what I have Variabe1_Int_rate Variable2_Orig_date Variable3_Purpose Variable4_Arrears 9.2 ND1 Unsecured 169000 0.65 1997-07 Secured ND3 2003-11 Unsecured 259231 0.65 ND3 Unsecured ND5 ND4 ND6 Secured ND2 Below is what i want: Variabe1_Int_rate Variable2_Orig_date Variable3_Purpose Variable4_Arrears 9.2 ND,1 Unsecured 169000 0.65 1997-07 Secured ND,3 2003-11 Unsecured 259231 0.65 ND,3 Unsecured ND,5 ND,4 ND,6 Secured ND,2 As before i would like to replace all ND by ND, (example ND1 becomes ND,1 etc). Thanks in advance for your help
... View more