Excel How to Split Cells Values


 
 

Home

Copyright 2014 - 2021 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home
Split first and last word or separated by delimiter or by number of characters In Excel

Split first and last names, or those values separated by a delimiter you specify such like (- or , or /, etc,,,), or even split by number of characters. Dose for Excel's Split utility can split cells  values easily with one click on huge worksheets.

  • Click DOSE Text Split
Excel Split by Delimiter
  • Split first and last words

1. Select range of cells to split and check First and last words option.
2. Then click 'Split' button. You will see the result as shown in the below screenshot.
Excel Split First and Last Words

Excel Split First and Last Words
Excel Split First and Last Words
  • Split column by delimiter

1. Select range of cells to split and check Split column by delimiter option.
2. Select a delimiter from the drop down list (Comma, colon, semicolon, etc..) or select 'Custom' and fill the delimiter in the text box, for example (- or , or /, etc...).
3. Select where you want to split from (Left-most-delimiter, Right-most-delimiter, each occurrence of the delimiter)
4. Then click 'Split' button. You will see the result as shown in the below screenshot.

Excel Split Column by Delimiter

Excel Split Column by Delimiter
Excel Split Column by Delimiter
Dose for Excel

Dose for Excel adds more than +100 new features and functions to your Excel.
Supported Excel versions: 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 14 days.

Dose for Excel
Dose for Excel
 











 
  • Demo

Excel Split by Delimiter
Excel Split by Delimiter
 
  • Split column by number of characters

1. Select range of cells to split and check Split column by number of characters option.
2. Set how many characters you want to split.
3. Select where you want to split from (Once, as far left as possible or Once, as far right as possible or Repeatedly).
4. In below example, we selected 'Once, as far left as possible' and '9' characters to split.
5. Then click 'Split' button. You will see the result as shown in the below screenshot.


Excel Split column by number of characters
Excel Split column by number of characters
Excel Split column by number of characters
Download Dose for Excel
HOME        PRODUCTS        INSTALLATION GUIDE        EXCEL TEMPLATES        EULA        AFFILIATES        SUPPORT        ABOUT US