Copy/paste from other application without delimiting it?

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

When I copy a paragraph from another application and try to paste it in a
cell in Excel, it automatically delimits it. Does anyone know how to keep it
from doing this?
 
not sure what you mean by "delimits" but try pasting into the formula bar at
the top of the screen instead of just the cell?
 
What is the de-limiter Excel uses?

Excel will store the Data>Text to Columns settings if you have used that at
some time.

Check to see what the settings are and clear de-limiters such as space or
comma or other(if set).

Save the workbook then try your copy/paste.

Or paste into the formula bar as has been suggested by dlw.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

delimited copy and paste 2
Possible text-to-columns bug 3
Copying data to new workbook and saving as text delimited 1
point as delimiter 1
text to column 10
How to use Windows command within Excel macros 2
Pasting Word table cell with paragraph markers into single Excel c 1
delimit using a formula 2

Back
Top