| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
paste text, auto text to clumns
Hi,
When I paste text (From SAP, save, file, in the clipboard ) into excel from the clipboard initially it will leave the text as-is, after which I am able to use 'text to columns', usibf the | to split the text. It works fine the first time. Doing it the second time on the day, Excel 2007 will automatically perform 'text to columns', but doing it incorrectly. The minus (-) is disregarded, it will put this numbers in as text. How can I control excel not to perform 'text to columns' automatically, when pasting text? kind regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does my text in a cell with wrap text and auto height get cut | Excel Worksheet Functions | |||
| Copy text from cell and paste it in a separate text box (contents tobe linked) | Excel Programming | |||
| User Form Text Box - auto delete prompt text | Excel Programming | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Hybrid Mode
