If you have this in LibreOffice Calc (see the picture below), you can convert it to a single line of text.
The test steps - LibreOffice 7.5.2.2
OS: Windows 11 Home
Download from the developer's website: https://www.libreoffice.org/download/download-libreoffice
1. Download LibreOffice from the link above and install it.
2. Select the cell where a single line will be placed.
Click 'fx'.
A new window shows, search 'textjoin'
Select 'TEXTJOIN' in Function then click 'Next>'
At Delimiter, type 'char(32)'. char(32) = space.
Click the box of Text 1.
Select the target rows (click the first rows, then hold shift key and click the last row).
In the box of Text 1, you will see something like this (picture below).
Click OK.
The single line of text is in the cell.
I copied that cell (in my case, C1) and pasted to Notepad.
In the picture below, A1 ends with 'centralise', A2 starts with 'rent'.
In the single line of text, I had ...centralise[space]rent...
Some people think about MS Word or similar apps for managing text but using Calc to do this task is very fast and easy.
The test steps - LibreOffice 7.5.2.2
OS: Windows 11 Home
Download from the developer's website: https://www.libreoffice.org/download/download-libreoffice
No comments:
Post a Comment