Forum Discussion
Keep trailing spaces in fields after Text To Columns
Hello everyone! New to the forum. Let me say first I am doing this with macros recorded in Excel. I am taking a text file which includes spaces in each row, and placing in Column A. I am th...
I don't know what that means either.
If I may ask, which part? And since you said either, I suspect someone else replied and removed their post. I realize now the paragraph about pipes is radically confusing. In a nutshell, for the rest of it, if I do a Text To Columns from a large string, and, say, characters 4-9 are 'AB ', I need those trailing blanks to be maintained in the cell. Same if the characters were '12 ' I need that five character total maintained.