Home 
Excel 2003 Concatenate Pull Information From Different Cells Together
Search MS Office A-Z | Search Web Pages/ Design A-Z
Pull Information From Different Cells Together
It pulls information from various cells and combines them into a statement, such as “The inventory status for widgets is 4,322 items in stock and 3,000 items on order.” In this example, the function is pulling “widgets” and the two numbers from three cells and combining them into a sentence. The function looks like this: =CONCATENATE(“The inventory status for “,F15,” is “,G15,” in stock and “,H15,” items on order.”) Each time the inventory numbers change, the text statement is updated, as well.