- TO ADD VALUES TOGETHER : =A1 + A2 OR SUM(A1,A2)
- TO SUBTRACT VALUES FROM EACH OTHER : = A1 - A2
- TO DIVIDE VALUES FROM EACH OTHER : = A1/A2
- TO MULTIPLY VALUES : = A1 * A2
- TO ADD PERCENTAGE TO A VALUE : = A1 + (A1*1.20) OR A1 + (A1 * 20%)
- TO SUBTRACT PERCENTAGE FROM VALUE : = A1 - (A1 * 20%)
- TO ADD A DASH (-)INFRONT OF A WORD eg. (-oem): ="-" & "oem"
- TO REMOVE A LETTER OR LETTERS EITHER FROM THE LEFT, RIGHT OR MIDDLE OF A CELL : = RIGHT(A1, LEN(A1)-1)
NOTE: THE DIGIT AT THE END REPRESENTS THE AMOUNT OF LETTERS YOU WANT TO REMOVE FROM EITHER SIDE. THE "RIGHT" REPRESENTS WHICH SIDE OF THE CELL DO YOU WANT TO REMOVE. THE A1 REPRESENTS THE CELL.
- TO ADD VALUES LIKE (+27 OR 64 ) TO NUMBER VALUES (9887878 OR 78998) TO CREATE 1 WHOLE NEW NUMBER : SELECT THE CELLS YOU WANT TO JOIN - PRESS "CTRL & 1" - PRESS THE LAST OPTION "CUSTOM" - THEN GO TO THE TYPE SECTION AND TYPE ANY NUMBER OF DIGITS YOU WANT TO JOIN WITH THE SELECTED CELLS. eg. (+27 OR 64 OR LONGER NUMBERS) THEN LEAVE 1 CLICK SPACE AND ADD # WHICH REPRESENTS EACH DIGIT FROM EACH CELL. CLICK "OK"
- TO JOIN TWO OR MORE VALUES TOGETHER USING CONCATENATE
=CONCATENATE(A1,A2,A3,A4) - TO MASS DELETE ROWS WITH EMPTY CELLS, SELECT THE COLUMN WITH EMPTY CELLS AND PRESS "F5" , THEN PRESS THE "SPECIAL" BUTTON AT THE BOTTOM- CLICK "BLANKS"- CLICK "OK"-RIGHT CLICK AND DELETE.
- TO SELECT CELLS WITH SAME VALUES EITHER YOU HIGHLIGHT THEM BY GOING TO CONDITIONAL FORMATTING- HIGHLIGHT CELL RULES-DUPLICATE VALUES.
OR FINDING THEM BY PRESSING "CTRL & F"- ADDING THE VALUE - "FIND ALL" - PRESS "CTRL & A" TO SELECT ALL SAME VALUES.