PURPOSE Splitting text separates combined data into usable fields. COMMON EXAMPLES Split full names, addresses, codes, comma-separated values, or combined category fields. STEPS Select the column, choose the text-to-columns or split option, and pick a delimiter such as comma, space, tab, or custom character. CHECK Review results carefully. Names and addresses often contain exceptions. BEST PRACTICE Split into empty columns so existing data is not overwritten.