In Excel, split the first and last word, or divide them by a delimiter or by the amount of characters
Split first and last names, or values separated by a delimiter you provide, such as (- or, or /, etc.,,), or even split by character count. On large worksheets, Dose for Excel‘s Split function may simply split cell values with one click.
- Click DOSE » Text » Split
- Split first and last words
- Check the “First and last words” option when splitting a range of cells.
- Then select “Split” from the drop-down menu. The result will be as seen in the screenshot below.
- Split column by delimiter
- Check the “Split column by delimiter” option after selecting a range of cells to split.
- Choose a delimiter from the drop-down menu (comma, colon, semicolon, etc.) or choose “Custom” and type in the delimiter in the text box, for example (- or, or /, etc.)
- Choose where you want to split (“Left-most-delimiter”, “Right-most-delimiter”, “Each occurrence of the delimiter”)
- Then select “Split” from the drop-down menu. The result will be as seen in the screenshot below.
- Split column by number of characters
- Check the “Split column by number of characters” option after selecting the range of cells to split.
- Set the number of characters you’d want to separate.
- Choose where you want to split (“Once, As far left as possible or Once”, “As far right as possible or Repeatedly”).
- We choose “Once, as far left as feasible” and “9” letters in the sample below.
- Then select “Split” from the drop-down menu. The result will be as seen in the screenshot below.
- Demo
More Features:
Excel Select Merged Cells
Quickly Select Merged Cells It seems a little difficult to select only merged cells in…
Excel Insert Empty
Insert Empty Rows Or Columns At Certain Interval In Excel If you ever want to…
Excel Formula Helper
Use Built-In Advanced Formulas In Excel You can quickly use built-in formulas without writing them…
How to insert a date picker in Excel
Add Date Pickers to Your Excel Sheets in No Time Effortlessly streamline data entry and…
Excel Batch Delete Option Buttons
Batch Delete Option Buttons In Excel Sheets Batch deleting option buttons in selected cells without…
How To Reverse Text Or Words In Excel
Reverse Text String Order In Excel Reverse any text the way you want, reverse all…