Explanation

Use Text to Columns when values are separated by a character such as:

  • Comma ,
  • Space
  • Tab
  • Semicolon ;
  • Other custom delimiters

Steps

Select Column → Data → Text to Columns → Delimited → Choose Delimiter → Finish

Example

Original:

Customer Data

Amit,Kumar,Sirsa

Neha,Sharma,Hisar

Rahul,Singh,Fatehabad

Choose Comma as delimiter.

Result:

First Name

Last Name

City

Amit

Kumar

Sirsa

Neha

Sharma

Hisar

Rahul

Singh

Fatehabad

Practice

Split the following data using Comma:

Amit,Keyboard,4000

Neha,Mouse,5000

Rahul,Monitor,25500

PreviousNext