Text to column in Libreoffice calc 🔥🔥
Hi friends
I am Rahul. Welcome to my channel OFFICE NOTEBOOK.
Is video me humlog discuss karenge Text to column in Libreoffice calc ke bareme.To aplogo ko a video bohot pasand ayega. Is video ko jaroor ant tak dekhiye.
You can expand cells that contain comma separated values into multiple cells in the same row.
For example, cell A1 contains the comma separated values 1,2,3 and cell A2 contains the text A,B,C.
Select the cell or cells that you want to expand.
Choose Data - Text to Columns.
You see the Text to Columns dialog.
Select the separator options. The preview shows how the current cell contents will be transformed into multiple cells.
You can select a fixed width and then click the ruler on the preview to set cell breakup positions.
You can select or enter separator characters to define the positions of breaking points. The separator characters are removed from the resulting cell contents.
In the example, you select the comma as a delimiter character. Cells A1 and A2 will be expanded to 3 columns each. A1 contains 1, B1 contains 2, and so on.
Channel ko jaroor SUBSCRIBE kar le.
Thank you.
Libreoffice writer Playlist - • Libreoffice writer tutorials for beginners...
#libreoffice
#libreofficecalc
#libreofficetutorial
#libreofficetutorialforbeginner