Text - Number separator tool

Hello all,

I'm working on a tool that covers the text to columns limitation with spaces.

When the data is delimited by spaces, using balance sheets, it separates the names into multiple columns, which is terribly annoying.

This tool I've been working on, allows to go around that problem.

I have other sheets in my original workbook that allow other more or less information according to the users' desire, but the one attached is just an example.

I need help to solve two problems:

When the numbers have the dots from the thousands separator (in here we work with dots for thousands and commas for decimals), it messes the formulas (in column I the 2's and the 6 should not appear), because that's actually a character, but since I do not know in advance if the numbers will be that big, I can't simply make it count that extra character;

The tool works as long as the numbers after the denomination fill all the columns. Depending from the type of accounting map used, I may know in advance if it's expected that a column is blank, and so, using the number of spaces separating the numbers, it fills the correct information. The problem is when the data has zeros as blanks. In this example worksheet, having 3 numbers is alright (they must be the Debit, the Credit, and depending from which is bigger, i know the right balance column - and yes, the row for the first example is completely random). But when I have two numbers is a huge problem because there are three possibilities: they're both credit (movement and balance), they're both debit (movement and balance), or the movements are equal and so the balance is zero. Does anyone have any idea on how this problem can be addressed?

Thank you all.