Three examples of utilizing the Excel TEXTSPLIT function.

Hello! Are you familiar with the TEXTSPLIT function, Excel beginners? Today, let’s explore three examples of using the TEXTSPLIT function. The TEXTSPLIT function in Excel divides text based on a delimiter, which can be useful for data processing. By looking at examples together, you can easily learn how to use the TEXTSPLIT function!

Example 1: Separating First and Last Names

One common example is separating first and last names. For instance, if you want to split the text in a cell, “홍길동” into “홍” and “길동,” how would you do it?

In the Original Data column, you have the value “홍길동,” which can be separated into last name and first name using the TEXTSPLIT function. For this, you should specify a space for the second argument of the TEXTSPLIT function. Input =TEXTSPLIT(A2,””,1) in the Last Name column and =TEXTSPLIT(A2,””,2) in the First Name column.

Example 2: Splitting Phone Numbers

Let’s look at splitting phone numbers as a second example. If you wish to separate an phone number in the format “010-1234-5678” into area code, exchange number, and subscriber number, how would you do it?

In the above example, with the value “010-1234-5678” in the Original Phone Number column, you can use the TEXTSPLIT function to separate it into Area Code, Exchange Number, and Subscriber Number based on “-“.

Example 3: Handling Email Addresses

Lastly, let’s look at how to handle email addresses. Email addresses are typically divided into username and domain using “@” as a delimiter, such as “example@email.com.”

In the above example, with the value “example@email.com” in the Original Email Address column, you can use the TEXTSPLIT function to separate the username and domain based on “@” and “.”.