Split Cell in Excel WITHOUT DELIMITER

Question

Split Cell in Excel either into 2 column in that cell, or 2 rows in that cell. How? WITHOUT DELIMITER. Shouldn't there just be a thing where you right click a cell, and can split it into columns, or split into rows?????

Answer 1

Hi,

Share some data to work with and show the expected result.

Answer 2

Or use Text to Columns in the Data Tools section of the Data tab of the ribbon:

Then use Fixed Width in Step 1 of the dialogues.

Answer 3

If the number of characters that you want to extract on the left (or on the right) is fixed, you can use LEFT and RIGHT.

For example, if the first part should be 4 characters, and the rest should be the second part:

=LEFT(cell, 4)

=RIGHT(cell, LEN(cell)-4)