stopping pasted text deliminate across multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 
Thanks for your assistance, spot on, also the issue applies to new
spreadsheets that are opened when an existing 'affected' sheet is active.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top