Excel Ignoring Tabs When Pasting From Word

Hi ... I suspect I somehow clicked on some option without realizing and I can't figure out how to get it back to normal ...

For no reason I can think of, Excel is ignoring tab stops when I paste text from Word into Excel.  Up till now, I copy the line of text with tabs from word and paste into a spreadsheet and the text separates into columns.  (Simple copy and paste - Cntr C in Word then Cntr V in Excel)

Now, instead of taking my line of text with four tabs and pasting into Columns A, B, C, D, it is pasting the entire text in column A.  Tabs are ignored, not even replaced by a space.  The only way I can get it to paste properly is to go into paste special and choose "Text".  (Choices in paste special are:

Microsoft Word Document Object

Picture (Enhanced Metafile)

Unicode Text


How can I get back to a simple copy (text with tabs from Word) to paste (in Excel with text separating into Columns at tabs)



Just tried pasting text with tabs again, and for the first time since May 3rd, it worked!  Here are the current version numbers I'm running ...16.0.8269.2886  version 1706 (Build 82292103)

For such a giant flaw, it sure took a long time to fix ... Glad our long national nightmare has come to an end!


2 people found this reply helpful


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated December 23, 2020 Views 1,238 Applies to: