For example Cell A1 contains 1234
And I want it to read 1,2,3,4,
Or in writer text of “abcd” becomes “a,b,c,d,” in text
Cheers Clive
For example Cell A1 contains 1234
And I want it to read 1,2,3,4,
Or in writer text of “abcd” becomes “a,b,c,d,” in text
Cheers Clive
That’s simple. Assuming your text (or a number convertible to text) is located in cell A1 just use in a different cell
{=TEXTJOIN(",";0;MID(A1;ROW(OFFSET(INDIRECT("a1");0;0;LEN(A1);1));1))}
(Don’t enter the curly brackets. They only show that the formula was entered for array-evaluation with Ctrl+Shift+Enter
.)
If your LibO version is 6.2 or higher you can also use
=LEFT(REGEX(A1;".";"$0,";"g");LEN(CURRENT())-1)
and there may be additional ways.
You cannot do this in ‘Writer’ of course since there is no reasonable concept of cell formulas (and the needed bag of functions). You can play with F&R the way shown with REGEX() then or write a “macro”.
Thank you Both very much play time.
Since 2020-02-09 or coming soon?