Again we split the text in the cell, how to split cells in excel, how to split a cell in excel

Опубликовано: 16 Октябрь 2024
на канале: Computerapia

909

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?