Split cells in Excel

How to quickly separate data in Excel

Enter any combination of characters to split text in the selected column

Cell Cleaner allows splitting cells by character, by mask, or by strings in Excel 2016, 2013-2007. You can choose to split text to columns or rows and be sure that your data will not be overwritten.

Free Download
7-day fully functional version

How to split cells in Excel by character

Use the option Split by character if you need to separate data in a column at each occurrence of the delimiters you pick or enter.

  1. Run the Split Text tool by clicking on its icon. Run the Split Text tool by clicking on its icon
  2. Select the column or cells where you want to split data.
  3. Expand the Split by character group on the add-in pane.
  4. You can separate cell contents in excel by comma, space, semicolon, or line break. It's also possible to enter any delimiter to the Custom field. Separate cell contents in excel by comma, space, semicolon, or line break
  5. If the values you want to split are separated by several successive symbols, tick off the Treat consecutive delimiters as one check-box.
  6. You can separate cell data to columns or to rows. Choose to split cell contents to columns or to rows You can split cell contents to columns or to rows
  7. Just click Split and to get the result.

How to split text in Excel by mask

Using the Split by mask option you can enter several delimiters for separating cell contents in Excel.

  1. Run the Split Text tool by clicking on its icon.
  2. Select the range of cells that you need to separate to several columns or rows.
  3. Expand the Split by mask group.
  4. Enter the delimiters you want to be used for splitting cells. Use asterisks to indicate the position of text. If asterisk is one of the delimiters, type the tilde sign before it, like ~*. Enter the delimiters you want to be used for splitting cells
  5. Choose if you want to split cells to columns or to rows. Choose to split cell contents to rows or columns
  6. Click the Split button and see the result.
Split cell contents by mask

How to split cells in Excel by strings

Use the Split by strings option to separate values based on a combination of characters.

  1. Select the range where you want to separate data cells.
  2. Expand the Split by strings group.
  3. Enter the strings one per line if values in the selected column can be separated by different strings. Enter the strings one per line
  4. Choose how you want to split cells - to columns or to rows. Choose to split cell contents to rows or columns
  5. Press the Split button.
Split cell contents by strings With the Split Text tool you can separate a column of text into multiple columns. Easily split data by any character, strings, or enter a mask for the expected results.
 
Contact us
 
  Publish your message on our support forum
 

Our working hours: 0am to 9am PST; 3am to 12am EST; 9am to 6pm CET.

Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard
 
 
Excel add-ins and Outlook tools - Ablebits.com