Скачать с ютуб How to Separate Columns in Excel | 3 Examples Using Delimiters and Fixed Width в хорошем качестве

How to Separate Columns in Excel | 3 Examples Using Delimiters and Fixed Width

I frequently need to separate Excel data into multiple columns—whether it’s full names, addresses or something else. In this hands-on tutorial, I’ll walk through three examples of how to split using delimiters (spaces and commas) and then how to work with fixed width separation. 00:00 – Example #1: Separating full name into first name and last name columns using a space delimiter 01:35 – Example #2: Separating address information using a comma delimiter 02:29 – Example #3: Separating zip codes with a fixed width