ElementsTitlePrefixNew TitleHas New TitleABC Lecture #1ABCABC Lecture #1ABC Lecture #2ABCABC Lecture #2Reading #1DEFDEF Reading #1Reading #2DEFDEF Reading #2Project #1GHIGHI Project #1Project #2GHIGHI Project #2New TitleHighlight all of these cells and copy, then highlight all of the Element cells and paste.if(contains(prop("Title"), prop("Prefix")), prop("Title"), prop("Prefix") + " " + prop("Title")) By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
