I am trying to do the Text to clumns command for columns where the cells look like this:
10000010011> 10101010101>01100111000> 101101010110
> is used to split the data into 4 columns.
Some data like for example this
000011001110 changes (all the first zeros are cut) turning it into this
Formatting as a text makes some data (011111110111000) look like this: 1,11111E+13.
Does anyone have a idea? I tried a lot of different formats.
I don't want to put a apostrophe in front of every input.