Excel Tips: Edit > Split

Split Cells

Split by Delimiters

How to break or split address into separated parts in Excel?

How to convert comma separated text string to list or rows in Excel?

How to quickly split date into separate day, month and year in Excel?

How to separate dollars and cents into two columns in Excel?

How to separate email addresses to username and domain in Excel?

How to separate whole number (integer) from decimal in Excel?

How to split a cell into multiple rows or columns based on a character/a word/carriage return?

How to split at any number in Excel?

How to split by delimiter and transpose cells in Excel?

How to split cell contents into columns or rows based on newline in Google sheet?

How to split cells by first space delimiter in Excel?

How to split cells into multiple columns or rows by carriage return?

How to split comma separated values into rows or columns in Excel?

How to split date and time from a cell to two separated cells in Excel?

How to split multiline cell contents into separated rows/columns in Excel?

How to split or break sentence into words in Excel?

How to split text by space/comma/delimiter in Excel?

Split by Width

How to break or split number into individual digits in Excel?

How to separate area code from phone number in Excel?

How to split numbers into columns in Excel?

How to split string by certain length in Excel?

How to split word or number into separate cells in Excel?

Split Names

How to extract middle name only or split names from full name in Excel?

How to split full name to first and last name in Excel?

Split Text and Numbers

How to separate text and numbers from one cell into two columns?

How to split / separate alphanumeric strings into two columns in Excel?

How to split a cell at the first number in Excel?

How to truncate number/text string in Excel?

Split to Rows

How to convert one cell to multiple cells/rows in Excel?

How to split a cell vertically in Google sheet?

How to split cell values vertically in Excel?

Others

How to quickly split cell into a table in Excel?

How to quickly split text string by case in Excel?

How to remove or split all merged cells in Excel?

How to reverse the concatenate function in Excel?

How to split a cell diagonally in Excel?

How to split cell into columns in Google Sheet?

How to split cell values into multiple columns in Excel?

How to split one cell contents into multiple columns in Excel?

How to split text into separate columns by capital letter in Excel?

Split Columns

How to separate positive and negative numbers into two columns in Excel?

How to split a column every other row in Excel?

How to split a long column into multiple columns in Excel?

How to split a long list into equal groups in Excel?

Split Data (Range)

How to split data into multiple worksheets based on column in Excel?

How to split data into multiple worksheets by rows count in Excel?

How to split range data into multiple workbooks in Excel?

Others

How to split a stacked bar chart in Excel?

How to split a workbook to separate Excel files in Excel?

How to split a worksheet into multiple panes in Excel?

How to split one single row to multiple rows in Excel?

How to stop splitting text to columns when paste data in Excel?