Differences

This shows you the differences between two versions of the page.

--- excel [2019/06/28 10:53]
zeppo [excel-formula-to-split-cell-text-based-on-char-count]
+++ excel [2019/10/10 10:06]
zeppo
@@ Line 1: / Line 1: @@
-**Search cells for specific text in cells and note it**
+ ====== Search cells for specific text in cells and note it  ======
   * =ISNUMBER(SEARCH("apple",A1))
@@ Line 31: / Line 31: @@
-To get just the first 3 characters of a cell :
+To get just the **FIRST** 3 characters of a cell :
@@ Line 37: / Line 37: @@
-To get everything AFTER the first 3 characters of a cell :
+To get everything **AFTER the first 3** characters of a cell :
@@ Line 43: / Line 43: @@
-To get the LAST 3 Charcters
+To get the **LAST** 3 Charcters
 =RIGHT(A1,3)
@@ Line 61: / Line 61: @@
   -     Click Finish
+====== CHANGE CELL FROM SCIENTIFIC TO STANDARD NUMBER ======
+https://www.techonthenet.com/excel/questions/remove_scientific.php
+====== REMOVE DUPLICATES FROM A COLUMN IN EXCEL ======
+REMOVE DUPLICATES FROM A COLUMN IN EXCEL
+Select the range of cells that has duplicate values you want to remove.
+Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
+Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.

ZeppoManx Wiki