Fixing broken numbers with VBA

[Playnine9]

Hi,

I've searched the forums and found this place to be really helpful many times, but I finally have a question that I can't find the answer to.

I have an automated CNC measuring table that checks the thickness of a piece of wood at various points along the piece.

Sometimes, my measuring device screws up and enters two values into one cell as such:

7.25 % good
7.45 % good
7.527.21 % ERROR

My question is: is there a quick way to take the error and split that number up into two parts (7.52 and 7.21), and put the 7.21 in the next line dynamically while measuring?

I can probably work figure out a lengthy workaround for this, but I was wondering if anyone had a quick, simple alternative to the former.

Thank you in advance,
-Drew

 

[Playnine9]

nevermind, i am just going to determine the length then cut anything past the first 4 digits