Blog - Text To Columns

Text To Columns

Text To Columns

Advance Excel

Text to columns

 

किसी भी  Cell के Contents  को  Columns में Separate करना

 Eg:-  1

 

 

           Select Data of column A

 

          Go to Data menu

 

         Text to columns

 

          Select delimted & next

 

          Select space & next

 

          Select  general option

 

           Finish

 

Result-

 

                                                                                           

Eg:- 2

 

 

Data menu

 

Text to column

 

Fixed with

 

Next

 

Arrange arrow

 

Next

 

Finish

 

 Result :-

 

      

 


356 9 months ago