Split a Cell in Excel - Gaintoearn

 

       _{As you become an expert in excels, splitting cells also consider one important criteria. Sometimes we get combine reports from software’s so based on our needs we can change the cells based on aspire.}

This process we can use tools called text to column.

This topic we are going to see both text as well as numerical figure segregation.

   _{1.  Split Date & Time in Excel
   2.  Split text into two or different cell}

_{1.  Split Date & Time in Excel}

_{Here I have a data including date and time and I want to split date and time separate.}

_{Step : 1} 

_{select cells which we need to segregate, then go to Data -> Click Text to Column ( Shown in image)}

Step : 2 

_{Once clicked below window will appear}

 

_{A ) Delimited : This we can give comma or space or semicolon of the text based on our needs}

_{B) Fixed width : Where we need to give space that we have to select manual, it’s used for text as well as numbers.}

Step : 3 

_{Now we are going to select Fixed Width to split date and time separate.}

_{once selected, click Next, then window will appear like this.}

_{Aero : aero shows separate the text. If you want to change the aero you can track and keep it where ever you required}

_{Now automatically appeared aero near the end of date. That means date one field and time another cell so we don’t want to track aero to any where. Now click Next below window will appear. This highlighted date one cell and time another cell.}

_{Now click Finish then below changes you can identify in the excel}

Step : 4 

_{Now you can change the format of date and time.}

                         _{i.     select date}

                         _{ii.   Go to home}

        _{ii              iii.   Click Format cells}

                        _{iv.   Choose more number format like below}

 

                          v .    Select below format then give OK.

                            _{vi.   Then cell appear only for date like below.}

      _{now date and time segregated.} 

      _{Note:  If you want to change time format, only for hh:mm then same process you can do it then select below format it will show only for hour and minute.}

 

   _{click ok.}

so now segregated date and time one cell into separate cell. Based on that you can do text also.

 

      _{2.  Split text into two or more different cell}

Step 1 :

For the above available in one cell contains name,employee id and contract.

I am going to segregate one cell into 3 different cells.

Select which you want to segregate - > Go to  Data - > Text to columns

         Click next and Finish

Click next and finish then it will appear like this.

This will helpful for you how to segregate text,numbers,date & time. Leave you comment below then I can understand as this helpful for you or else you have any doubt on this.