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 [2018/10/25 11:46]
zeppo
excel [2019/06/28 10:54] (current)
zeppo [excel-formula-to-split-cell-text-based-on-char-count]
Line 27: Line 27:
  
 https://​support.office.com/​en-us/​article/​split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23 https://​support.office.com/​en-us/​article/​split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23
 +
 +====== excel-formula-to-split-cell-text-based-on-char-count ======
 +
 +
 +To get just the **FIRST** 3 characters of a cell :
 +
 +
 +=LEFT(A1,3)
 +
 +
 +To get everything **AFTER the first 3** characters of a cell :
 +
 +
 +=IFERROR(RIGHT(A1,​LEN(A1)-3),""​)
 +
 +
 +To get the **LAST** 3 Charcters
 +
 +=RIGHT(A1,​3)
 +
 +
 +https://​stackoverflow.com/​questions/​49850210/​excel-formula-to-split-cell-text-based-on-char-count
  
 ====== IMPORTED TEXT NOT RECOGNIZED AS A DATE ====== ====== IMPORTED TEXT NOT RECOGNIZED AS A DATE ======
excel.1540485997.txt.gz ยท Last modified: 2018/10/25 11:46 by zeppo