Hi there,

I have data input to process that comes like this

comany A ................ 17

company B .........20, 25

comp, C ...................36

No, Dr. Peter ...........55

I need to separate the first part even if there are dots (to be preserved) from the last part. An ideas?

Thanks!

Best way to do this is find a pattern. If the sample you give is representing the data you need to work on the you might go for the space-dot in the determination of the position() of the first dot in the row. Then use the left () with the length of the position found.

So what you basically need is to find the first appearance of " ." with the Position() function.

Then use the result in the Left() function to filter let text on the left.