HLOOKUP

HLOOKUP
=HLOOKUP(F2,$B$2:$C$10,1,FALSE)

Read More..

Removing spaces

1.       Highlight column in question.  In this case I will highlight column A.

NB: Make sure to highlight the required column or all spaces in the other columns will be replaced as well.

2.       Select key CTRL + H...which is the keyboard shortcut for Find and Replace.  Or go to the Home tab> Then go to the Editing group and Click “Replace”.

3.       In the “Find What” text box, enter 1 single space by pressing the space bar

4.     Make sure there are no data and no spaces in the “Replace With” text box

5.       Click “Find Next”> Then click “Replace All”.  This will replace all the spaces in the column highlighted.

6.       In my case 10 spaces have replaces with nothing that is there are no longer any spaces in the highlighted column.

Read More..