Text to Columns with EACH character in sepearte column?

**flipmode** · 10-05-2007, 10:51 AM

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?

**Mark@Work** · 10-05-2007, 12:21 PM

If you import your data into column A of Sheet1 as TEXT then
set Cell A1 of Sheet2 to :
=MID(Sheet1!$A1,COLUMN(),1)
Replicate this across and down as required.

You will now have a single character in each cell of Sheet2.

Are you sure this is what you want?

Mark.