Split Text Into Different Cells

Get eSignatures done in a snap

Prepare, sign, send, and manage documents from a single cloud-based solution.

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
Outstanding Online Support I have used Pdffiller for the past 4 years to file ta...
Outstanding Online Support I have used Pdffiller for the past 4 years to file tax returns for an investment group with over 40 members. I made an error when creating my template and when I went to print the 40 documents an erroneous number was appearing, the result of my error in creating the document. Fortunately Pdffiller has an online support staff. So many online companies require you to submit a ticket and then promise a 24 to 48 hour response time. Pdffiller offers that option but they have an outstanding online chat support. I had the benefit of working with Ryan and got access to him immediately upon opening up the online chat support. This was in the evening but Ryan thoroughly researched and tested my issue. Sadly the only option that appeared to be the answer was to create a new set of 40 documents which Ryan was willing to teach me how to create the docs in way that would avoid this error. When I expressed my issue with not having another 6 hours to re-create my work, Ryan persisted in finding a work around that was very creative and saved me from over six hours of new work!!! Needless to say I was ecstatic!!! Thank you Pdffiller for not only a great product but an online support staff that truly cares about helping customers get the results they require!!
Kevin D. Smith
5.0
If I had my own business If I had my own business, would highly recommend .
If I had my own business If I had my own business, would highly recommend . I don't need forms that often.
Brenda Scrafield
4.0
Pretty good tool overall Pretty good tool overall, sometimes when you hit the Ta...
Pretty good tool overall Pretty good tool overall, sometimes when you hit the Tab button it jumps to a field father down the page, but all in all really easy and accurate.
Rachel Leonhart