User Tools

Site Tools


excel

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
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))   * =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) =RIGHT(A1,​3)
Line 61: Line 61:
   -     Click Finish   -     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.
  
  
  
excel.txt ยท Last modified: 2019/10/10 10:06 by zeppo