98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Word Training and help » Word Advanced
Word Advanced
Resolved · Low Priority · Version 2010
Valerie has attended:
Introduction to Management course
Excel Intermediate course
Excel Advanced course
PowerPoint Introduction course
Word Introduction course
Word Intermediate course
Word Advanced course
Word Advanced
if i inherit a list of names to use in a mail merge and they are in one field instead of first name, last name. how would I separate them?
RE: Word Advanced
Hi Valerie
Can I check first how your mailmerge data is stored? Sometimes it is in Access. If Excel then you can separate the names using the Text to Columns feature on the Data tab.
1.First insert 2 blank columns to the right of your Names column.
2. Highlight the names column then select Data, Text to Columns.
Select Delimeted
3. Click on space if the firstnames and surnames are separated by a space.
4. Choose a destination cell at the top of the first inserted column.
5. Press ok.
Hope that does it!
Doug Dunn
Best STL
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Useful Word 2010 HotkeysHotkeys will help you work faster and improve your productivity when using Word 2010, they are otherwise known as shortcuts. We have highlighted a few of them below. |