- Joined
- Apr 21, 2024
- Messages
- 4
- Reaction score
- 0
The code below in D3 seperates text from numbers.
My numbers contain spaces which I want to preserve for seperation later.
In the attached image, such as D3, I would like 12 13 presented as 12 13 and not 1213.
Also in example D4 has a limited output of 132. How do I get an output of 13 252?
=TEXTJOIN("",TRUE,IFERROR(MID(C3,SEQUENCE(20),1)+0,""))
My numbers contain spaces which I want to preserve for seperation later.
In the attached image, such as D3, I would like 12 13 presented as 12 13 and not 1213.
Also in example D4 has a limited output of 132. How do I get an output of 13 252?
=TEXTJOIN("",TRUE,IFERROR(MID(C3,SEQUENCE(20),1)+0,""))