Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop text to data split
I frequently use 'Data / Text to Columns' to split peoples names into
separate columns, one column for given name & one column for surname. If I then do a copy & paste for other data, every word is placed into a separate column. The only way I can get it to stop, is to close Excel down and reopen. I suspect there is something in my setup that is causing this, but cannot find where/ what it is. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How do I paste text data into ONE cell only? | Excel Discussion (Misc queries) | |||
Group and Count Text Data More Efficiently | Excel Worksheet Functions | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) |