Hi,
in my sheet I have the following certain columns which content i want to split into separate columns.
Column F (9 positions long) --> value on position 1 goes into once column, value on position 2 goes into one column, value on position 3 goes into one column etc..
Column G (24 positions longs) --> value on position 1 goes into once column, value on position 2 goes into one column, value on position 3 goes into one column etc..
Column H (90 positions long) --> value on position 1 goes into once column, value on position 2 goes into one column, value on position 3 goes into one column etc..
How can I do that my using a formula.. I have tried the MID formula but does not get it work.
I have attached the file and would be very grateful if one one can help out
Br,
MMExample split string to columns.xlsx
Bookmarks