Remove Chars in Call Based on Condition

Hi everyone

I am looking for a way to modify the cell values via VBA in a way that it removes chars of a cell value based on a condition

i.e. I have values (all in the same column) auch as

505.k8i
2005.fd
30453.uere


What I would like to do is only show the value before the decimal separator (.) plus one additional char before that
So my result would be
50 (5.k8i being removed)
200 (5.fd being removed)
3045 (3.uere being removed)

Any chance to achieve this?

Thanks and regards
FD

Given that the examples are in column A in range A1:A3, try this:

Please Login or Register  to view this content.

Another way is to do it by RegEx.

Cheers,
berlan