Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Text to columns issue


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.
Reply With Quote


--
sminor
------------------------------------------------------------------------
sminor's Profile: http://www.excelforum.com/member.php...o&userid=37606
View this thread: http://www.excelforum.com/showthread...hreadid=572297

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Text to columns issue

http://support.microsoft.com/kb/127132

--
Jim
"sminor" wrote in
message ...
|
| 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.
| Reply With Quote
|
|
| --
| sminor
| ------------------------------------------------------------------------
| sminor's Profile:
http://www.excelforum.com/member.php...o&userid=37606
| View this thread: http://www.excelforum.com/showthread...hreadid=572297
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merge text from 2 columns into 1 then delete the old 2 columns sleepindogg Excel Worksheet Functions 4 March 30th 06 07:25 PM
Text to columns - one way street? Al Excel Discussion (Misc queries) 4 November 17th 05 04:31 PM
How do I convert from text to columns automatically on import? byosko Excel Discussion (Misc queries) 1 November 16th 05 11:21 PM
comparing columns of text (cross-searching) WorkingWithText Excel Discussion (Misc queries) 0 November 8th 05 02:30 AM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM


All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"