In search engine market excel is an essential tool. Why? You use it for lead monitoring, unsubscribe lists, organizing ad groups, keyword lists, and sorting a number of other large files full of words that would otherwise waste hours of the controllers time. So today I was making a keyword list to organize Ad groups and thought I would share a tip to help everyone combine 2 separate cells of words into one cell of words. As you can see with the image below the words in column a called "words" and the cells in column b called "text" are combined in column c. This is done by entering the following process into column c:
=concatenate(A1," "B1)
or
=CONCATENATE(A9," ",B9)
depending on which cells you want to combine!
No comments:
Post a Comment