check if on position 1 in an cell is an character

[Marcel1958]

in an cell i have the value : v 8,00
now i have to check if there is an v in the first position and if so fill the new cell with 8,00
if there is another character then the new cell must be empty

 

[TonyJollans]

Hi Marcel1958,

If your value is in cell A1, then in B1 put ..

=IF(LEFT(A1,1)="v",MID(A1,3,LEN(A1)-2),"&quot

This checks for the "v" and takes everything from position 3 onwards if it finds it.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.