Visual Basic for Applications/Character 1D Arrays

Summary

 * This VBA code module is intended for any Microsoft Office application that supports VBA.
 * It allows strings to be loaded into one-dimensional arrays one character per element, and to join such array characters into single strings again.
 * The module is useful in splitting the characters of a single word ,something that the Split method cannot handle.

Notes on the code
Copy all of the procedures below into a VBA standard module, save the workbook as a xlsm type, then run the top procedure to show that the process is accurate.