stopping pasted text deliminate across multiple cells

P

Paul from NZ

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
 
J

Juan Pablo González

Paul,

Did you do a Text to Columns with the back slash as the delimiter ? look at
this:
 
P

Paul from NZ

Thanks for your assistance, spot on, also the issue applies to new
spreadsheets that are opened when an existing 'affected' sheet is active.
 
Top