You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
(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
thank you, exactly what I was looking for.
I don't want a video; I just want step by step instructions for table-to-text!!! I can't find the command in Word 2010!
Here are instructions:
I've also added these to the post.
First of all, why do you insist on changing place of everything each time you introduce a new version of MS Office. And why do you post a video?? that does not work?? to show a simple thing like convert text to table. Looking forward to changing to Open Office also at work...
I'm sorry the video didn't work for you. I did add the instructions in text below the video for people who prefer to read instead of watch.
l don't want to watch your stupid video. Just give me the steps!
The steps are written out below the video. I hope that helps.
I can't see anything, it's just a black square.
Besides, it's so childish to use a video instead of saying the bar, tab, etc. where to find what is sought.
I'm sorry the video isn't appearing, but the instructions are listed below the video.
@Nitzan, can you tell us the version of your browser and what operating system you're using? We occasionally run into this problem so it helps to know what technology you're using.
That was really helpful. Thanks
Hi Joannie, I've seen the text instructions - the video doesn't want to display for me either, but it could be a firewall issue - but when you say Data Group I was struggling to find that.
If you select a table you get the Table Tools view but the tab selected defaults to 'Insert'.
I did find the function eventually on the Layout tab once in Table Tools.
I'm posting here in case other people are unable to find the function quickly. I'm finding the new interface pretty confusing.....
Running Office Pro Plus 2010 on Windows 7 Enterprise
Thanks for your post. When you select the table, click the Table Tools Layout tab, and then you'll see the Data group on the far right side.
For help with the new interface, have you had a chance to try the interactive guides? office.microsoft.com/.../office-ribbon-find-commands-FX101851541.aspx