Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

word advanced

ResolvedVersion 2010

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Word tip:

Assign shortcut keys to styles

If you're a fan of using styles, you can create your own shortcut keys to apply styles quickly.

Go to Tools - Customise, then to the Options tab. Click on the Keyboard button on this tab.

Scroll down the list displayed on the left, until you see Styles. Click on Styles to select it, then you will see a list of styles currently available for use on the right.

If a style you wish to assign a shortcut key to does not appear in the list on the right, close out of the dialogue box, apply the style, then follow the steps above again - you should then see the style listed.

Enter your shortcut key combination in the 'Press new shortcut key' box. If the shortcut keys selected are already assigned to another function in Word, it will be displayed in the box.

If you want to overwrite the existing function for the shortcut keys you have chosen, click Assign.

If you wish to assign a unique set of shortcut keys, use Backspace to remove the shortcut keys you have typed in; then try typing in another key combination. Click Assign when you have a key combination you are happy with.

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.