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
