Hi!
I can’t understand how to use the CONCAT function. In the sheet attached I tried to use the function, but it doesn’t recognize that is a function.
My LO is
Versión: 6.4.6.2
Id. de compilación: 1:6.4.6-0ubuntu0.20.04.1
Subprocs. CPU: 4; SO: Linux 5.4; Repres. IU: predet.; VCL: gtk3;
Can somebody help me please?
The cell is formatted as text, so the formula is not recognized.
EDIT:
Clear the formula, give the cell a different formatting and retype the formula.
If this answers your question, please click (
→ 
)
My operating system: Windows 10 Home (x64)
My LibreOffice versions: 7.0.5.2 (x64); 7.1.0.3 Portable
I tried to change to other types, but no way.
I don’t think that formula is not recognized because the cell format is text.
Furthermore, which format I should use for a cell that must receive text strings to concatenate?
E. g. General
I tried it as well
=CONCAT(F4,G4,H4,I4) error
=CONCAT(F4;G4;H4;I4)
or
=F4&G4&H4&I4
I cut out any cell from column C and pasted it into B4 and typed the formula.In an Answer @Smurf2 had written this comment: (Answer deleted)
Sorry Schiavinatto, but your solution is not working.
Sorry Schiavinatto, but your solution is not working.
Because as I wrote in my answer, the cell is formatted as text.
PKG I as I said before, the cell type is not the problem, I tried various types including “default” but is not working.
Make the formula on another spreadsheet and cut and paste on it.
I already had this problem, and I solved it the way above.
@PKG I as I said before, the cell type is not the problem,
But that’s the problem! Clear the formula,
give the cell a different formatting and retype the formula.
See the complement in the answer above.