Results 1 to 3 of 3

Text to Columns with EACH character in sepearte column?

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2007
    Posts
    3

    Text to Columns with EACH character in sepearte column?

    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?

    Attached Files Attached Files
    Last edited by flipmode; 10-05-2007 at 10:54 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1