Wednesday, April 9, 2008

concatenating in excel

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!

concatenating in excel

No comments:

Post a Comment

Thanks for visiting InteractiveMedias. If you need to contact me directly please visit dveit.com, twitter.com/desaraev or email me at interactivemedias@gmail.com