There is no in built function in excel for removing whites spaces when it appears at the end of a text or middle of a text , but you may wonder why can't we use the Trim Function. Yes, Trim () Function works when there is a white space at the beginning of a text area. But It doesn't work with with all instances.

I have also tried filtering white spaces and  do a "Find and Replace" But It replaces all white spaces within a cell , what I actually mean is when there is a single space between 2 words. This removes all the white spaces.

I finally found google sheet is a good solution to solve this problem in no time. What you have to do is

1. Sign into your Google account. 
2. Create a blank spreadsheet. 
3. Now go and copy the data areas in your excel.
4. Now Paste the copied data into newly created google sheet. 
5. All the white spaces  will have been removed. 
6. Now copy the data from google sheet into your excel. 

This tutorials shows you how to count specific words in excel cell. As shown in the picture we are going to find the number occurrences of word "Prince" in Cell "A2". On Cell "B2" is the word that we are searching for. The formula in cell c2 as below.

=(LEN(A2)-LEN(SUBSTITUTE(A2,B2,"")))/LEN(B2)  

A2= the text from which we look for specific word
B2= the text which we are searching for

Description about this function. 

Subtract the length B2 cell from length of A2 cell and dive the all length by length of of B2 cell which gives the numbers of occurrences.

The functions used here are Len() and Substitute. 

This article intend to show how to resize an already existed PDF's page size. Let say you have a PDF page which is in A2 size probably you would encounter problem with viewing in small device or you may feel it is too large to fit on your screen.

So solution you would find is how to resize it. I'm a longtime user of Adobe Acrobat and Nitro PDF. Using both programs you can resize it.

How to Resize Using Adobe Acrobat.

1. First open your document which you would like to resize. 


2. Now Go to File >Print option. Actually you don't need a printer. By default it will be Adobe Acrobat. 


3. In the Open window Choose Properties which is located Top right. In the pop window choose Adobe PDF Settings.


4. Now Choose the Adobe PDF Page Size as you wish.


5. Click Ok and Save the file.

When it comes to get your money into your pocket it is vital important how are you going to withdraw. These questions may rise in your mind what payment methods are available to you, which is best for you? Choosing a right payment method can reduce your cost and can save your time.