Dear all.
My question is simple, but i did not find the answer. For example : I would like write in one cell
44254
'-------
12000
(I do not want setting of cell size, but I can change letter size or type. in this example the type is mixed ) I would like see all in A1 cell, in three lines.
Thank you your time and help.
You can use the CTRL-Enter (after first two “words”) for line feeding inside a cell.
The type of the “result” will be pure string. You can not put two numeric value in one cell.
Or you can use the Data validity - when you want to choose one value (numeric or textual value) from a list.
Thank you Tibor.
If i would like in formula (a = “44254”; b="--------";c=“12000”) d=CTRL+ENTER
d ?=? Carryage Return (013) ? OR Line Feed (037)
Another variant:
=TEXTJOIN(CHAR(10);;A2:A4)
Many thansk for Zizi64, and sokol92, your answer. All your solution was perfect if i need to choose, I choose Zizi64 because he was the first. Best Regards for all.
The real solution depends on if you want a string constant or you want a formula result in the target cell.