Topics tagged concatenate

Topic	Replies	Views	Activity
Pad the data from other cells (used via formula) with leading zeroes English calc , date , concatenate , cell-format	9	5279	September 29, 2023
How to save part format cell in formula? More English calc , macro , concatenate , conditional-format , cell-format	2	1115	February 13, 2022
Solved: Calc: Concatenate does not carry over leading zero English calc , time , concatenate , zero , leading , libreoffice-511	3	4681	July 31, 2021
Column A contains data. B1=(a whole number generated by a formula). C1=(a whole number generated by a formula). How do I concatenate the range A(B1):A(C1)? English calc , range , concatenate , variable	8	1716	January 14, 2021
Reorder text string from within one cell with a different separator English calc , concatenate	4	992	August 1, 2021
Can I use one List Box to write in two different fields from different tables? English base , listbox , concatenate	2	1214	September 10, 2020
Syntax for nested CONCAT and ROUND functions in one cell English calc , concatenate , nesting	11	2997	July 28, 2020
How to display a number with decimals? English calc , decimal , concatenate	2	1685	June 20, 2020
How can I add decimals to a concatenate formula? English calc , formula , decimal , concatenate	5	2933	June 15, 2020
Need Sheet2 to always mirror Sheet1 but w/ some columns combined English calc , transpose , indirect , concatenate	6	1315	May 26, 2020
Concatenate currency input with number and treat as currency English calc , format , concatenate , join , cell-format	2	1912	April 16, 2020
How to format concatenated data to access data in another sheet/cell English calc , date , sheet , concatenate , edate	9	1665	July 31, 2021
Formatting in cells with concatenated data English calc , date , concatenate	3	3523	June 19, 2019
missing concatenated text values are showing up as "0" in result English calc , concatenate , skip-empty-cell	1	710	June 16, 2019
=concatenate function won't work English calc , concatenate	5	4792	March 28, 2019
Copy cellvalue to end of another? English calc , merge , concatenate	3	3031	March 22, 2019
[SOLVED]Conditional formatting on cells using containing "CONCATENATE" English calc , format , conditional , concatenate	4	4790	February 27, 2019
Field Concatenation with Line Feed / New Line in Base English base , query , concatenate , blank-line	7	8296	July 31, 2021
How to italicize (underline, make bold) one string in a concatenation expression of two strings? English calc , style , concatenate	3	3355	July 31, 2021
Is there a way to reference the result of Randbetween() with If()? English calc , index , if-function , concatenate , randbetween	3	1047	July 31, 2021
Calc: formula: why are tildes auto-replacing commas? English calc , formula , tilde , concatenate , comma , fedora-20 , libreoffice-428 , rand-between	17	5717	July 31, 2021
How to save part format cell in formula? English calc , concatenate , cell-format	2	788	July 31, 2021
Concatenation of a formula English calc , formula , csv , concatenate , error-501	6	3388	July 31, 2021
Concatenate Footnotes? English writer , footnote , concatenate	6	1338	July 31, 2021
From one row take the last cell with text English calc , cell , concatenate , empty	6	2753	July 31, 2021
Concatenate cells and formating text English calc , cell , format , text , merge , concatenate	12	12274	July 31, 2021
Values in a Combo Box English base , sql , combobox , concatenate	3	3908	July 31, 2021
Concatenation of multiple cells on multiple rows English calc , concatenate	4	4912	July 31, 2021
Function for strings (ConcatIf) like SumIf English calc , concatenate	3	2465	July 31, 2021
I want to concatenate an =, a cell value with a number and a letter to make a cell reference formula English common , concatenate , sign , equal	4	8258	July 31, 2021