Excel How to Split Cells Values


 
 

Home
HOME           PRODUCTS           EULA           AFFILIATES           SUPPORT           ABOUT US

Copyright 2014 - 2018 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 values In Excel

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

  • Click DOSE Text Split
Excel Merge Cells Or Rows Or Columns
Excel Merge Cells Or Rows Or Columns
Excel Split Values
  • Split first and last words

1. Select range of cells to split and check First and last words option.
2. Then click Split. 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 words separated by

1. Select range of cells to split and check Split words separated by option.
2. Fill the text box with the character that will be separate words according to it, for example (- or , or /, etc...).
2. Then click Split. You will see the result as shown in the below screenshot.
Excel Split Words Separated by

Excel Split Words Separated by
Excel Split Words Separated by
Dose for Excel

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

Dose for Excel
Dose for Excel