View Single Post
  #1   Report Post  
Paul from NZ
 
Posts: n/a
Default 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