Hi Max,

This formula works kind of. Assuming that your data is concatenated in
column I with a "." in between and what follows are numbers no longer than 4
digits, then in j1 you could type:
=(LEFT(I1,FIND(".",I1)-1)) & (REPT("
",(((MAX(FIND(".",$I$1),FIND(".",$I$2),FIND(".",$I $3),FIND(".",$I$4),FIND(".",$I$5),FIND(".",$I$6))) )-(FIND(".",I1)))+1)) & (RIGHT(I1,4))

What this formula does is takes the text on the left side of the ".",
concatenates it with a number of spaces equal to the largest number of
character spaces that "." is from the left in column I minus the current
cell's number of characters from "." to the left; concatenated with
everything that follows the "." on the right.
The only problem with this is that the amount of 'space' a space would make
is different than what a 'X' would take. So although it does separate the two
pretty good, it's not perfect.

Hope this helps.