What is Split Text Into Different Cells?

Splitting text into different cells is a useful function that allows you to divide a single cell content into multiple cells based on a specified delimiter. This can be handy when you have a large amount of text that needs to be organized into separate categories.

What are the types of Split Text Into Different Cells?

There are several types of text splitting methods that you can use, such as:

Split by comma or other specified character
Split by space or line break
Split by fixed width

How to complete Split Text Into Different Cells

To split text into different cells, follow these steps:

01
Select the cells that you want to split
02
Go to the 'Data' tab and click on 'Text to Columns'
03
Choose the delimiter that you want to use for splitting the text
04
Click 'Finish' to complete the text splitting process

pdfFiller empowers users to create, edit, and share documents online. Offering unlimited fillable templates and powerful editing tools, pdfFiller is the only PDF editor users need to get their documents done.

Thousands of positive reviews can’t be wrong

Read more or give pdfFiller a try to experience the benefits for yourself
5.0
Works great.
Works great. Wish it would have windowed copy and paste in the event I want to duplicate an area...like adding an extra signature line.
Arjen S.
4.0
This is a good app.
This is a good app. It could be improved with navigation that's a bit less clunky - more intuitive. I also wish there was a way to fill out forms without having to recenter, re-size, re-font the text so it looks normal in the document.
Elizabeth E.
5.0
Awesome software.
Awesome software..convenient, straightforward, no hassles, fast, make my work super easy..love it. highly recommend it! thanks so much..my boss even asked me how was it, i said excellent good investment. thanks again. ;0)
Anna W.