Home |
Search |
Today's Posts |
#1
|
|||
|
|||
stopping pasted text deliminate across multiple cells
When pasting text that contains back slashes, text is split into multiple
cells using the back slash as a deliminator, this occurs automatically and I wish to stop it. Pasting as text or unicode text via paste special makes no difference. Example text 'C:\Program Files\Common Files\Microsoft Shared' splits into 4 cells in a row and the back slashs removed Using Excel 2003 SP1 |
#2
|
|||
|
|||
Paul,
Did you do a Text to Columns with the back slash as the delimiter ? look at this: -- Regards, Juan Pablo González Excel MVP "Paul from NZ" <Paul from wrote in message ... When pasting text that contains back slashes, text is split into multiple cells using the back slash as a deliminator, this occurs automatically and I wish to stop it. Pasting as text or unicode text via paste special makes no difference. Example text 'C:\Program Files\Common Files\Microsoft Shared' splits into 4 cells in a row and the back slashs removed Using Excel 2003 SP1 |
#4
|
|||
|
|||
Thanks for your assistance, spot on, also the issue applies to new
spreadsheets that are opened when an existing 'affected' sheet is active. "Juan Pablo González" wrote: Too fast on the Enter... http://www.mrexcel.com/td0129.html -- Regards, Juan Pablo González Excel MVP "Paul from NZ" <Paul from wrote in message ... When pasting text that contains back slashes, text is split into multiple cells using the back slash as a deliminator, this occurs automatically and I wish to stop it. Pasting as text or unicode text via paste special makes no difference. Example text 'C:\Program Files\Common Files\Microsoft Shared' splits into 4 cells in a row and the back slashs removed Using Excel 2003 SP1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
text from one column into multiple columns | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) |