Showing posts with label MS Word. Show all posts
Showing posts with label MS Word. 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..

Find & Replace Trick to remove Half of the line in Word

Here is a example if I want to remove Hello Friends/This is from below paragraph
Hello Friends/This is RAJESH wants to say Hello to you.
Hello Friends/This is DINESH wants to say Hello to you.
Hello Friends/This is MAHESH wants to say Hello to you.
Hello Friends/This is JOHN wants to say Hello to you.
Hello Friends/This is DIANDRA wants to say Hello to you.
Hello Friends/This is ROBERT wants to say Hello to you.
Hello Friends/This is WINDOWS wants to say Hello to you.
Hello Friends/This is GREAT wants to say Hello to you.
Now you just want to have words from first names only…(from the Bold Words)
Try this…
Step-1 Select the text which you want to replace..


word find and replace1
Step-2 Alt +E+E = Find & Replace
Paste whatever you want to remove in find what box
image
And now click replace.. and here is the result.

Best of MS Office Commands…Word Find and Replace

Hi, friends…., while working in office if you have adequate knowledge of computers many tasks can be done very easily..
as a Pharma worker…….I have to deal with big data list for Liasoning works…and one of them is licence lists…
just have a look at below…list of 1000 items

1. XYZ Syrup.
Each 5ml. Contains *, :

xxxx                   200.00 mg.


-,xtt.. IP, tttkkk IP, mmmmmm IP, rrrrr IP,……..and like that…

to be converted like… below and one product on one page means…..thousand of pages..
XYZ Syrup.
Each 5ml. Contains *, :
“Specific Word”
xtt                  IP
tttkkk             IP
mmmmmm     IP
rrrrr                 IP

I mean without table and with simple text duly looking clean and clear with nice formating…….and one item on a page…
also to be inserted some text above column one text………and some on coloumn two text…like..
Brand Name…