Consolidating text data in excel Chatmobil adult

If you don't know to search for Concatenate, then you will never learn that the concatenation operator is an ampersand.

Start with a basic formula of =A2&B2 This will give you the result shown in C2 below: This is a good start.

Sometimes it is useful to merge two or more columns in Excel, such as first and last names or components of addresses.

You can also do the opposite and split information within a cell into separate columns.

Although it is advertised as an advanced class, there are always some basic concepts that the students don't seem to know. He has a database with first name in Column A and Last name in column B.