Hello i have try to convert this instruction
=IF(ISNUMBER(FIND("\",F1)),MID(F1,1,(FIND("\",F1)-1)),F1)

in vba ...
I want to format a sheet that contain ""\""and evrything after
this command work fine for me but i want to use it in a vba sub() that i will create

but so far ... i had no chance
can someone help me or give me some clue how i can do that

thank you
have a great day