Wednesday, December 30, 2020

Excel: Split Word Into Separate Cells In Excel

 See https://www.extendoffice.com/documents/excel/1697-excel-split-word-into-letters.html


In a blank cell next to your data, C1 for instance, enter this formula:
     =MID($A1, COLUMNS($A$1:A$1), 1)


2 comments:

OneNote Math Operations

  Supported arithmetic operators Operator Meaning Example +  (plus sign) Addition 3+3 -  (minus sign) Subtraction Negation 3-1 -1 *  (asteri...