Forum Discussion

Nm_growthmarketing's avatar
Nm_growthmarketing
Copper Contributor
May 19, 2022

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  a list of  “extended stay” + 1 word.

Triming all words before “extended stay” and all words after “extended stay + 1 word”.

 

Here are some examples. 

 

suites extended stay = extended stay

suburban extended stay in charlotte = extended stay in

suburban extended stay in wilmington nc = extended stay in

extended stay hotels cleveland ga = extended stay hotels

suburban extended stay hotel hermitage tn = extended stay hotel

 

What formula could I use?

Thanks

excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Silver Contributor
    May 19, 2022

    Nm_growthmarketing 

     

    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...

     

     

     

Resources