Computer Forum Forum Index
Register  FAQ Profile Log in to check your private messages Log in Register 

Split column and move information

 
Post new topic   Reply to topic    Computer Forum Forum Index -> microsoft word vba beginners
View previous topic :: View next topic  
Author Message
Ugly Girl
Guest
PostPosted: Sat Nov 24, 2007 5:00 pm    Post subject: Split column and move information Reply with quote
I have a table with several columns. One column has entries like this, 24
Nov 2007. Can I split this column into 2 columns and move the 2007 into the
new column at the same time? Thanks

Jane
Back to top
Google
Sponsor
PostPosted: Sat Nov 24, 2007 5:00 pm    Post subject: Advertisement
Back to top
Jay Freedman
Guest
PostPosted: Sat Nov 24, 2007 8:30 pm    Post subject: RE: Split column and move information Reply with quote
The simplest way (no macro needed):

- Click in the table and select Table > Convert > Table to Text. In the
dialog, select to separate text with tabs (this should be the default).

- Go through the resulting text, either manually or with a Replace
operation, to insert a tab between the two parts of each date.

- Select all the text that belongs in the table. Click Table > Convert >
Text to Table, and choose Tabs as the separator.

--
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org


"Ugly Girl" wrote:

Quote:
I have a table with several columns. One column has entries like this, 24
Nov 2007. Can I split this column into 2 columns and move the 2007 into the
new column at the same time? Thanks

Jane


Back to top
Display posts from previous:   
Post new topic   Reply to topic    Computer Forum Forum Index -> microsoft word vba beginners All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Computer Forum