I am importing text file in Excel, but all data is importing in a column I want to split a column data into 3 different cells. How can I do it please suggest.
In this thread user wants to split a cell into 3 and more cells as per data requirement. To fulfill this requirement we use “Text to Column” option.
Text to Columns: - This function is used to split a single column of text into multiple columns.
Let’s take an example and understand how we can use this function to split a single cell.
We have a list of addressesin column A which contains the entire address in a single cell. We needto split the address into separate columns.
There are 3 steps in the Text to Columns function:-
preview box. If your data has comma as the delimiter which is mostly the case, you can select the comma check box.
You can see above that the text from one cell in column A has been split into the column B:F. This is very useful when you receive the data as in column A and need to split it into multiple columns for further analysis and reporting.
Note:- If you merge data in Excel then will cell will not be split in other cells through Text to Column.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.