I have a spreadsheet where I need to add text before the content that is in the cells in a specific column.
But not every cell in the column has content in it, so I want to leave the blank cells alone.
How would one do that?
- The question is related to Calc and you tagged base (which addresses the question to people having expertise in LibreOffice Base module. Please retag
2) Please show how your data look like and how you want it to look like (personally I got no imagination about the task to be performed). Eventually a simple `=IF(ISBLANK(A1);"";"Text to be added " & A1)` in a helper column, is what you search for or you are looking for a `Edit -> FInd & Replace` solution. But right now it is even not clear whether the text to be added is the same for all cells (having content) in the column or the text to be added itself is changing (depends of the cell).