I have a complex text file that needs to be converted into excel file. The excel file after being converted will not delimited by symbols or tabs, but instead spaces. The spaces between columns are not standardized, hence the text to column function in excel will not work. I have attached the text file and also the the desired output when converted to excel.
Desired_Output_01.xlsx (25.4 KB)
Margin Detail Report _ SD _Test.txt (33.2 KB)
How you or business does this operation manually? As you said it will not delimited by symbols or tabs, but instead non standard spaces, it will not be reliable solution to convert text to excel without properly formatting and defining the columns.
Thanks,
Ashok 
hi @ashokkarale this process is an exercise for me. so the challenge will be on how to make the text file into the desired output file. I am stuck with converting the text file content. And the only hint for the exercise is to use regex