Text to columns issue

  • Thread starter Thread starter sminor
  • Start date Start date
S

sminor

Some how I got set up so that when I paste text into an excel sheet it
auto does the text to columns funtion. Each word is in its own cell. I
would very much like to know how I got set up in this way and even more
how I can stop it. I have opened new sheet and books and the same thing
still happens so I think it must be some sort of global setting but I
just can't find it.

Thanks in advance.
 
is there some event code parked in thisworkbook event module
right click the excel icon on the left of the file menu. click VIEW CODE. in
the module which opens is there any macro in
Private Sub Workbook_Open()

End Sub
referring to some text to columns.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to columns issue 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
text not always in same cell 2
Row text to columns 2
why won't text-to-columns work here? 6
Count cells if next column has text 2
Special Text to Column question 3
Text to Columns macro 1

Back
Top