Showing posts with label Find & Replace Tips. Show all posts
Showing posts with label Find & Replace Tips. Show all posts

How to create Multiple Mailing Labels Per Page in Word Without Using the Mail Merge Wizard.






Hi, Friends, Again a Simple Office Idea…to Work Small and Do It smartly.
I just wanted to create  mailing labels one for each recipient but multiple records on each A4 Size Paper so that I can cut them and paste to my envelopes since the Printer was not accepting large envelopes.

Just Like this…..


Here is my data sheet in Excel.


So my first option was to create labels in word mail merge.
I did open my data base in mail merge and started creating the Labels.
But to my surprise I can get only one Label per page ….or more labels on one page with same…data…i.e. one label at once or same label on full page.

How to remove…words or digits from a line in MS Word or Excel

Hi, Friends…another useful post…for you..find and replace tips
Here is a simple line…containing words and digits.

Salary for the Month of APR Is Rs 2000
Salary for the Month of MAY Is Rs 3000
Salary for the Month of JUN Is Rs 4000
Salary for the Month of JUL Is Rs 5000
Salary for the Month of AUG Is Rs 6000
Salary for the Month of SEP Is Rs 8000
Salary for the Month of OCT Is Rs 9000
Salary for the Month of NOV Is Rs 105000
Salary for the Month of DEC Is Rs 2300
Salary for the Month of JAN Is Rs 25800
Salary for the Month of FEB Is Rs 22556
Salary for the Month of MAR Is Rs 224

Now I would like to just get the nos in above paragraph.
First Select the Paragraph.
Start with Alt+E+E (Find & Replace Shortcut)
image
Click on More..