You can use your favorite social network to register or link an existing account:
[f] [t] [in] [msg]
Or use your email address to register without a social network:
Username:Choose password:
Re-enter password:
Email address:
Re-enter email address: Submit
Close Sign in
Sign in with these social networks:
[f] [t] [in] [msg]Or enter your username and password
Username:Password:
Forgot your password?
Sign In
Close Account linking Welcome , Do you have an existing blogs.office.com account?
Yes, please link my existing account with for quick, secure access.
Sign in name:Password:
Link accounts
No, I would like to create a new account with my profile information.
Sign in name:Email address:
Re-enter email address:
Register
Close Microsoft Office Office Blogs Word Blog Home All Blogs Products Word Excel PowerPoint Outlook Access OneNote Publisher Office Web Apps Perspectives Office Casual Office in Education Office Exec Office 365 Subscribe to our RSS feed
Send to friendRSS for post comments2007 Office system21st Century DocumentsBuilding Blockscitation & bibliography toolsco-authoringcollaborationcompatibilityCompatibility Packcontent controlscreativitydesigndeveloperdocument reviewhelpimageslegal scenarionew default file formatsnewspersonalstylesvideoWordWord 2010Word Tech DetailsWord tips and tricksUnfiltered HTMLUnfiltered HTML Word video: Convert a table to text by Joannie Stangeland on March 28
(Note: This post was first published in September 2010.)
If you have text, you can convert that into a table. You can also convert a table back into text.
I've been seeing quite a few questions about this, so I thought it would make a good "Word of the week" video.
In this example, the table contains names and addresses. I want to convert that to comma-deliminated text so I can use it in a mail merge.
Let's take a look:
If you just want the text version of the instructions:
Click in the table. On the Table Tools Layout tab (one of the tabs that appears when you click in the table), in the Data group, click Convert to Text. In the dialog box, specify how you want the text separated.
For more information on tables, see Add or delete a table.
And for more information on mail merge data sources, see Use mail merge to create and print letters and other documents.
-- Joannie Stangeland
Tags: Word Office Blogs CommentsComments: (28) Collapse
Joyce McDaniel 14,898 Posts Wish you would give out copies to people who cannot afford it. Would be a great gift for us.
28 Sep 2010
Joannie Stangeland 333 Posts Dear Joyce,
Thank you for your comment. I know it's hard--especially in this economy. Microsoft does have a program for donating software to nonprofit organizations (www.microsoft.com/.../softwaredonation.mspx) to help them help others.
-- Joannie
29 Sep 2010 Rebecca 14,898 Posts Since the video doesn't work on my work computer, can you just post the directions? I'm a new MS Office 2010 user and am having some difficulty keeping a positive outlook on this new system.
1 Oct 2010 Joannie Stangeland 333 Posts Dear Rebecca --
Sure. Click in the table. On the Table Tools Layout tab (one of the tabs that appears when you click in the table), in the Data group, click Convert to Text. In the dialog box, specify how you want the text separated.
-- Joannie
1 Oct 2010 fahira20 14,898 Posts hi, would u plz tell me how to convert text to a table? the video on top does not play. plz tell me step by step thanks
3 Oct 2010 Joannie Stangeland 333 Posts Fahira20 --
Instructions for converting text to a table are here: office.microsoft.com/.../add-or-delete-a-table-HA010370560.aspx.
-- Joannie
4 Oct 2010 Sherry Foster 14,898 Posts I get how to convert text to table but in 2010 can you convert table to text? I don't see that on the menu optins anywhere.
13 Oct 2010 Joannie Stangeland 333 Posts Sherry --
The video shows you how. But in case you can't see it, Click in the table. On the Table Tools Layout tab (one of the tabs that appears when you click in the table), in the Data group, click Convert to Text. In the dialog box, specify how you want the text separated.
-- Joannie
19 Oct 2010 teter.debbie@gmail.com 14,898 Posts Where is the video - all I see is "Let's take a look" then there is nothing to follow. It used to be simple you had a choice convert text to table or convert table to text.
21 Oct 2010 teter.debbie@gmail.com 14,898 Posts Where is the video? It is not in your initial post. So I followed the last post - table tools tab only gives me table style option,s, table styles, draw borders - where are the data options or even the the formula options that used to be available
21 Oct 2010 Joannie Stangeland 333 Posts teeter.debbie --
I'm sorry you aren't able to see the video. I'd appreciate hearing what browser you're using, because maybe it's a browser issue.
As for converting: To convert text to a table, select the text, click Table (on the Insert tab), and then click Convert Text to Table. To convert a table to text, select the table, and then click the Table Tools Layout tab (it sounds like you're on the Design tab).
Best wishes.
-- Joannie
21 Oct 2010 Morris 2 Posts Joannie, converting table to text seems pretty straightforward. My goal is to be able to create a line of text with the first word flush left, and the second word flush right (to the right margin), all on the same line, without first using table and hopefully not using tabs. Is there a single command somewhere that would allow me to select the line and create what I think of as a justified line?
27 Oct 2010 Joannie Stangeland 333 Posts Morris,
These Word 2003 instructions will work for Word 2010: office.microsoft.com/.../vary-alignment-within-a-single-line-of-text-HP005188448.aspx.
However, if you're going to do a lot of lines, I think tab stops is your better bet.
-- Joannie
27 Oct 2010 Joannie Stangeland 333 Posts P.S. In fact, when you use the procedure I linked to, Word is inserting tab stops.
-- Joannie
27 Oct 2010 Morris 2 Posts Thanks. I had not known that procedure in 2003. For a single line, it does the job.
27 Oct 2010 1 2 Next > CommentsComments: (loading) Collapse
other Microsoft blogs Official Microsoft Blog Microsoft On The Issues The Windows Blog Bing Community Zune Insider Major Nelson other product blogs Office For Mac Office Web Apps InfoPath Project Visio other Office blogs Office IT Pro Office Updates Office Labs SharePoint Information Workers Legal | Trademarks | Privacy Statement © 2011 Microsoft Corporation. All rights reserved.
No comments:
Post a Comment