Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
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? |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
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? |
#3
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
Select Edit Replace (or press Ctrl+H).
In the "Find what" field, type ^t. Make sure the "Replace with" field is empty. Click "Replace All". -- Regards Lene Fredborg DocTools - Denmark www.thedoctools.com Document automation - add-ins, macros and templates for Microsoft Word "RAJ2828" wrote: 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? |
#4
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
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? |
#5
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
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? |
#6
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
Thank you for all of your ideas but I have tried them all to no avail. For
some reason if you try to copy and past multiple columns from Excel into Word the columns end up becoming these tabs which would be fine to delete manually except that there are over 5000 of them to be dealt with. Also, the "find/replace" option doesn't seem to want to do them all at once. It only lets me repalce one damn tab at a time - EVEN - when I hit the "replace all key". There must be an easier solution that lets you just remove all the tabs with the push of a button. Or atleast I hope there is. Thank you all again and if anyone comes up with anything new I would really appreciate the news. Thanks again! Sincerely, RJ "Lene Fredborg" wrote: Select Edit Replace (or press Ctrl+H). In the "Find what" field, type ^t. Make sure the "Replace with" field is empty. Click "Replace All". -- Regards Lene Fredborg DocTools - Denmark www.thedoctools.com Document automation - add-ins, macros and templates for Microsoft Word "RAJ2828" wrote: 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? |
#7
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
Can you describe how you're pasting from Excel into Word?
Try this. After selecting the material in Excel and copying to the clipboard, in Word, choose Edit - Paste Special, and tell us what the default paste option is (it should be selected). If you choose one of the formatted options (RTF or HTML), it should paste the selection as a Word table. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "RAJ2828" wrote in message ... Thank you for all of your ideas but I have tried them all to no avail. For some reason if you try to copy and past multiple columns from Excel into Word the columns end up becoming these tabs which would be fine to delete manually except that there are over 5000 of them to be dealt with. Also, the "find/replace" option doesn't seem to want to do them all at once. It only lets me repalce one damn tab at a time - EVEN - when I hit the "replace all key". There must be an easier solution that lets you just remove all the tabs with the push of a button. Or atleast I hope there is. Thank you all again and if anyone comes up with anything new I would really appreciate the news. Thanks again! Sincerely, RJ "Lene Fredborg" wrote: Select Edit Replace (or press Ctrl+H). In the "Find what" field, type ^t. Make sure the "Replace with" field is empty. Click "Replace All". -- Regards Lene Fredborg DocTools - Denmark www.thedoctools.com Document automation - add-ins, macros and templates for Microsoft Word "RAJ2828" wrote: 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? |
#8
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
I am selecting columns in Excel and then "right-clicking" and selecting
"copy". Then I open up Word and "right-click" and select "paste". Also, I tried looking for the "paste special" option in Word and I can't find it. Do you know where it is? "Herb Tyson [MVP]" wrote: Can you describe how you're pasting from Excel into Word? Try this. After selecting the material in Excel and copying to the clipboard, in Word, choose Edit - Paste Special, and tell us what the default paste option is (it should be selected). If you choose one of the formatted options (RTF or HTML), it should paste the selection as a Word table. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "RAJ2828" wrote in message ... Thank you for all of your ideas but I have tried them all to no avail. For some reason if you try to copy and past multiple columns from Excel into Word the columns end up becoming these tabs which would be fine to delete manually except that there are over 5000 of them to be dealt with. Also, the "find/replace" option doesn't seem to want to do them all at once. It only lets me repalce one damn tab at a time - EVEN - when I hit the "replace all key". There must be an easier solution that lets you just remove all the tabs with the push of a button. Or atleast I hope there is. Thank you all again and if anyone comes up with anything new I would really appreciate the news. Thanks again! Sincerely, RJ "Lene Fredborg" wrote: Select Edit Replace (or press Ctrl+H). In the "Find what" field, type ^t. Make sure the "Replace with" field is empty. Click "Replace All". -- Regards Lene Fredborg DocTools - Denmark www.thedoctools.com Document automation - add-ins, macros and templates for Microsoft Word "RAJ2828" wrote: 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? |
#9
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
how can I remove all tabs from a document?
In any version of Word, Alt+E followed by S should work.
In Word 2003 (and earlier), click Edit (in the menu), and Paste Special should be among the choices. In Word 2007, click the little down arrow at the bottom of the Paste button (in the Home ribbon tab). Paste Special should be listed. In Word 2007, you can also use the new shortcut key, Ctrl+Alt+V. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "RAJ2828" wrote in message ... I am selecting columns in Excel and then "right-clicking" and selecting "copy". Then I open up Word and "right-click" and select "paste". Also, I tried looking for the "paste special" option in Word and I can't find it. Do you know where it is? "Herb Tyson [MVP]" wrote: Can you describe how you're pasting from Excel into Word? Try this. After selecting the material in Excel and copying to the clipboard, in Word, choose Edit - Paste Special, and tell us what the default paste option is (it should be selected). If you choose one of the formatted options (RTF or HTML), it should paste the selection as a Word table. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "RAJ2828" wrote in message ... Thank you for all of your ideas but I have tried them all to no avail. For some reason if you try to copy and past multiple columns from Excel into Word the columns end up becoming these tabs which would be fine to delete manually except that there are over 5000 of them to be dealt with. Also, the "find/replace" option doesn't seem to want to do them all at once. It only lets me repalce one damn tab at a time - EVEN - when I hit the "replace all key". There must be an easier solution that lets you just remove all the tabs with the push of a button. Or atleast I hope there is. Thank you all again and if anyone comes up with anything new I would really appreciate the news. Thanks again! Sincerely, RJ "Lene Fredborg" wrote: Select Edit Replace (or press Ctrl+H). In the "Find what" field, type ^t. Make sure the "Replace with" field is empty. Click "Replace All". -- Regards Lene Fredborg DocTools - Denmark www.thedoctools.com Document automation - add-ins, macros and templates for Microsoft Word "RAJ2828" wrote: 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all tabs from word document | Microsoft Word Help | |||
how do i remove or rename tabs in the templates dialogue box | Microsoft Word Help | |||
How do I remove unwanted tabs on the templates dialogue box | Microsoft Word Help | |||
remove tabs from Word template dialog? | Microsoft Word Help | |||
remove default File, New template tabs | Microsoft Word Help |