![How would I get CONCAT to concatenate only values from a certain row and a certain column? It works on the first cell but not the rest (screenshot included, more info in How would I get CONCAT to concatenate only values from a certain row and a certain column? It works on the first cell but not the rest (screenshot included, more info in](https://preview.redd.it/531xlpdyhet91.png?width=640&crop=smart&auto=webp&s=e7f9ce6ba64622f761fcaea4a1c053f6a2a0aa58)
How would I get CONCAT to concatenate only values from a certain row and a certain column? It works on the first cell but not the rest (screenshot included, more info in
![LibreOffice Calc – splitting contents of cells into multiple columns (e.g., splitting commas) – Ryan and Debi & Toren LibreOffice Calc – splitting contents of cells into multiple columns (e.g., splitting commas) – Ryan and Debi & Toren](https://www.ryananddebi.com/wp-content/uploads/2018/01/splitcells.png)
LibreOffice Calc – splitting contents of cells into multiple columns (e.g., splitting commas) – Ryan and Debi & Toren
![Calc: Find & delete last- or first certain amount of positions in a line of text - English - Ask LibreOffice Calc: Find & delete last- or first certain amount of positions in a line of text - English - Ask LibreOffice](https://ask.libreoffice.org/uploads/asklibo/original/2X/d/d75c0c6ae5fbbf86616ab804fbc9ccd235d45edb.jpeg)
Calc: Find & delete last- or first certain amount of positions in a line of text - English - Ask LibreOffice
![worksheet function - LibreOffice Calc: how to pad number to fixed decimals when used within formula? - Super User worksheet function - LibreOffice Calc: how to pad number to fixed decimals when used within formula? - Super User](https://i.stack.imgur.com/4UK2e.png)