[vicsireland] Re: Formatting query
- From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Mon, 13 Nov 2006 10:37:28 +0100
Hi Maureen!
You could open the document, place the cursor on one of the tabs and
select it by pressing shift-cursor-right. Then copy with ctrl-c. open
the find and replace dialog with ctrl-f and paste the tab symbol into
the find field. Press shift-tab once and then cursor-right. That'll get
you into the replacement area. Tab down to replace all and press enter.
Since you've left the replace with field empty, all the tabs will be
removed and replaced with nothing.
If you still have the Excel sheet there is an easier way.
Open the Excel sheet and press ctrl-a to select all. Switch to the Word
document and press alt-e for the edit menu and go down to paste special,
press enter. You'll get a list box to choose a format from. Select
unformatted text and press enter. The contents of the Excel sheet will
be pasted without any delimiters. It'll keep the line breaks and basic
cell structure, but to a sighted person it'll look untidy, because the
cells won't be aligned.
Cheers,
Robbie
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of maureen newell
Sent: Samstag, 11. November 2006 10:25
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Formatting query
An excel document saved to "word" how do I delete the tabs therein, or
can I? Do I have to go through the whole document line by line and
delete each tab?
Help greatly appreciated.
Maureen.
Other related posts: