I have to do this kind of stuff daily & I find the fastest way is to keep a second spreadsheet with a cascading formula builder that concantentes any new phrase, (or in you case abbrivation) I add to the list.in columns C & D
So three columns FUNCTION, C16 = LATEST-ORIGINAL, D217=LATEST-REVISION
Then in Cell E217 copy down =CONCATENATE(E216,”,”,C217,”,”,D217) which copies the formula line above (E216) then adds your new phrase.
You can build massive formulas in seconds. For example this strips out numbers
=(CLEAN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B9,9,”|”),8,”|”),7,”|”),6,”|”),5,”|”),4,”|”),3,””),2,”|”),1,”|”),0,”|”),CHAR(42),”|”),CHAR(43),”|”),CHAR(44),”0″),CHAR(45),””),CHAR(46),””),CHAR(47),””),CHAR(58),””),CHAR(59),””),CHAR(60),””),CHAR(61),””),CHAR(62),””),CHAR(63),””),CHAR(64),””),CHAR(91),””),CHAR(92),””),CHAR(93),””),CHAR(94),””),CHAR(95),””),CHAR(96),””),CHAR(123),””),CHAR(124),””),CHAR(125),””),CHAR(126),””)))
Lock the last one down /ec / esv ENTER ENTER & copy across into a new column of your sheet & Jobs a good un