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)

Renaming filenames, remove leading characters

This superuse post describes how a set of forward slashes (/) can be used to delete leading characters (except .) from a file name. One slash is required for each character to be deleted. I've confirmed the behavior on a Windows 10 machine.

ren "abc-*.txt" "////*.txt"
  abc-123.txt        --> 123.txt
  abc-HelloWorld.txt --> HelloWorld.txt

 ren "????*.*" "////*.*"