Forum Discussion
How to import raw .txt data into Excel
I have files of raw testing data in .txt form that I need to import into Excel spreadsheets. The .txt files are formatted as follows: X47312804237ACDBBADCADBCDBDCCBDAACCDACBA (The lette...
=DROP(TRANSPOSE(BYROW( SEQUENCE(LEN(A1)), LAMBDA(x, MID(A1, x, 1) ) )),,12)
You can try this formula if you work with Office365.
Great Lambda function! I'd suggest replacing the '12' in the drop function with a dynamic solution IF the student's ID is not 12 letters/digits long.
