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
Last revision Both sides next revision
excel [2019/06/28 09:48]
zeppo [excel-formula-to-split-cell-text-based-on-char-count]
excel [2019/06/28 10:54]
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 :
  
  
 =IFERROR(RIGHT(A1,​LEN(A1)-3),""​) =IFERROR(RIGHT(A1,​LEN(A1)-3),""​)
 +
 +
 +To get the **LAST** 3 Charcters
 +
 +=RIGHT(A1,​3)
  
  
excel.txt ยท Last modified: 2019/08/20 09:26 by zeppo