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

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

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

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