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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
transfering excel data word

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Transfering excel data to word

Transfering excel data to word

ResolvedVersion 2003

Andrea has attended:
Excel Introduction course

Transfering excel data to word

How do I get excel name & addresses to print out on word document.

RE: transfering excel data to word

Hi Andrea

Thank you for your question and welcome to the forum.

If you are transferring a single address from Excel into a Word document, this can be done by copying and pasting from Excel into Word.

To do this:
1. Select the name and address in Excel, and copy.
2. In the Word document, paste the name and address. A little smart tag with a clipboard icon on it will appear at the bottom right of what you have pasted.
3. Click on the Smart Tag and select the Keep Text Only option. This will remove the Excel data from the table format that it is pasted in to begin with.

If you are looking to transfer addresses for a mass mailing, then use the Mail Merge wizard in Word (Tools - Letters and Mailings - Mail Merge).

Kind regards
Amanda

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.