Excel cells will hold your text as you enter them, however, if the text is long, it can run into other cells. You will need to make the Excel cells fit the text.

2] Remove dashes in Excel by using the Find and Replace method. This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

In Excel, select the cell, group of cells, or entire column that has the text you want to split. It'll need to contain two pieces of data separated by a "delimiter." This'll usually be a comma ...

Merge & Center: This option merges cells into one and centers the text. However, only the text from the leftmost cell is kept. Merge Across: This option merges cells across from each other into one.