Thank you. Moo's formula seems to work a little better, though it's not applicable when I have 99cv or lower
For instance, sbehera's give a "#VALUE!" error when the cell contains just "170cv"
So let's say the formula should work in the following cases:
always extracting only the number before "cv"170cv xxxx
170cv
xxxx 170cv
xxxx 170cv xxxx
50cv xxxx
50cv
xxxx 50cv
xxxx 50cv xxxx
Thanks again for your kind help!![]()
Bookmarks