Forum Discussion
formula with a irregular field
I have a big file with just one column A the only thing in common is that each line has 133 characters on it. I try to use Text to Columns but did not work because the spacing is not the same. I try ...
I am trying to split in columns but the data don’t follow a pattern like the 3 samples I place with the results
I know you tried Text to column feature in excel. However, in that feature, did you check the box next to "Treat consecutive delimiliers as one"?
