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)


No comments:

Post a Comment

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 instanc...