Hello friends ,
This time something light and good.
Data in column A, cells with numbers without a space, in column C, should change that will be with a space.
For example ,
182024 Should be 1 8 2 0 2 4 ,
The size of the characters is different,
In Excel 2016, has the TEXTJOIN function, it has of course an advantage, but not necessarily especially in this example, In my opinion.
Conditioning is, without volatile functions ,And NO UDF !
Good luck!
David
This time something light and good.
Data in column A, cells with numbers without a space, in column C, should change that will be with a space.
For example ,
182024 Should be 1 8 2 0 2 4 ,
The size of the characters is different,
In Excel 2016, has the TEXTJOIN function, it has of course an advantage, but not necessarily especially in this example, In my opinion.
Conditioning is, without volatile functions ,And NO UDF !
Good luck!
David