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
excel [2019/06/28 10:53]
zeppo [excel-formula-to-split-cell-text-based-on-char-count]
excel [2019/06/28 10:54] (current)
zeppo [excel-formula-to-split-cell-text-based-on-char-count]
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)
excel.txt ยท Last modified: 2019/06/28 10:54 by zeppo