Build 2 new EXCEL vba macros from existing EXCEL vba macros

We need to copy 2 existing EXCEL VBA macros, and merge them with existing functionality from another vba macro. These functions parse data that is pasted into a cell, and separate and format in various ways.
Also need a fix to allow up to 6 decimal places for these macros.