I've been searching through here and almost found what I'm trying to do, but not quite...
I have a non-formatted text file that I copy and paste into excel. It all pastes into column A. I want to take each character, no matter if it's a letter, number or symbol, and put each into it's own column. In the end I want a "grid" look.
I can do this with "text to columns" and choose "fixed width" and click on each column, but that takes a long time. None of the wildcards I've seen mentioned seem to work. Any ideas?
![]()
Bookmarks