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