How to combine text from 2 cells into 1 cell in Ms Excel

This is how you can combine text contents from 2 cells into 1 cell using formula. You can even insert your custom text in between, before or after the combined text.

To combine text contents from 2 cell into 1 cell, use the "&" to join them together:

A1&B1

If you want to insert a space in between the 2 combined text:

A1&" "&B1

If you want to insert a hyphen in between them:

A1&" - "&B1

If you want to add your custom text before the combined text:

"custom text "&A1&B1

If you want to add your custom text after the combined text:

A1&B1&"custom text"

You can also combine the text together using "CONCATENATE" function:

• CONCATENATE(A1,A2)
• CONCATENATE(A1," ",A2)

via (http://office.microsoft.com/en-001/excel-help/use-formulas-to-edit-correct-and-proofread-text-RZ006183133.aspx?section=12)