If your Excel cell or row contains two or more values, you can split that data across multiple cells. For Excel to divide the values, however, the cell must contain a delimiter, a character that ...

A Social Security number consists of three strings of digits separated by hyphens. Historically, the first was an area number, which relates to the resident's geographic location; the second was a ...