>>>I have some text in Word that looks like this (there's much more really):
>>>
>>>
>>>Client
>>> Account
>>> Patient
>>> Coverage
>>> Insurance Case
>>>
>>>
>>>I want to get that into one column with one row per line in Excel. That's easy. Keeping the tab formatting isn't. It gets stripped out if I copy paste as text, or convert the text to a table, and then paste. How can I keep the tab so it indents in Excel?
>>
>>How about converting it, in Word, into a table first?
>
>That's one of the things I tried. You must have missed it in the post.
Indeed, I missed it.
However, it works for me. However, when converting to table (in Word), you have to tell it to use tabs as delimiters. In other words, just pressing the "Table" button may not work, because the default delimiter is something else. Giving the commands through the menu does, if you select Tab as delimiter. The idea is to have level 2 items in column #2.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)