Hello everyone, you are on the computer channel, and today in this short video, I want to answer the question from the comment of one of the viewers of my channel, how to split a cell in Excel that does not have a separator.
I will show you one way with formulas, how to split text in a cell, very often we are faced with the case when there is some kind of separator between the necessary text, so you need to go to the ribbon - Data - Text by columns, and specify a sign as a separator, which is between the data. There will be such a division.
But what if we need to select two characters from the text at the beginning of the text into one cell, and the remaining text into another?
Watch video Again we split the text in the cell, how to split cells in excel, how to split a cell in excel online without registration, duration hours minute second in high quality. This video was added by user Computerapia 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 909 once and liked it 28 people.