Forum Discussion
Building a list with Keyword plus one word from a list of phrases
Hi, I'm trying to find a way of building a list of keywords plus one word, from a list of phrases. I have a list of phrases where “extended stay” repeats hundreds of times. I would like to build ...
I'm going to point you in a general direction, given your general description. Do some research on Excel's many "Text Functions" using this page as a starting point. https://exceljet.net/excel-functions
Scroll down on that screen until you see this list of Text Functions (this image does not show all of them). In particular I'd suggest CONCATENATE and TRIM, based on your description, but scan each of them to get an idea of how extensively you can manipulate text...