Format

L

lbierer

I am trying to take a column on a excel spreadsheet and transfer it to
notepad or a general text without it changing all format. How do I do this?
 
D

Dave Peterson

What happens when you select the column, edit|copy
and paste into NotePad?
 
L

lbierer

It takes everything with it, the cells, etc and changes the format so I have
words all over the page. Does this make sense?
 
D

Dave Peterson

Maybe--I guess it depends on what's in those cells in that column.

Are they single words/short phrases or what?

If you put =len(a1) and drag down (point at the correct column), do you see
large numbers or small numbers.

If you have funny characters in there (carriage returns/line
feeds/tabs/unprintable characters), maybe that's the problem.

And you are pasting into NotePad--that simple text editor--not WordPad (that
supports lots of formatting), right?
 
Top