I had the same thought. If the OP doesn't want the text as a table, it would
still make more sense to paste as a table and then convert the table to
text, separating with appropriate characters.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site:
http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Herb Tyson [MVP]" wrote in message
...
When pasting a spreadsheet into Word from Excel, the default is to convert
it into a table.
The OP's question makes me wonder if they might've pasted first into
Notepad, selected/copied there, then pasted into Word (or pasted as
unformatted). In either case, if they're subsequently converting into a
table, this seem rather round-about when the spreadsheet could be pasted
as
a table in the first place.
--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com
"Suzanne S. Barnhill" wrote in message
...
Tab characters? If you really want to do this, you can search for ^t and
replace with nothing or a space, but this will give you one big
unmanageable
blob of text; it would make more sense to use Table | Convert | Text to
Table, separating at tabs.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup
so
all may benefit.
"RAJ2828" wrote in message
...
I have copied an excel spreadsheet into both Word and Notepad. How can
I
remove all the tabs that were automatically created by the Excel
columns?