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
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)
Thanks!