AFAIK - if there are letters, it is always 2-leter, so simple formula would be:
=IF(CODE(A2)>=65,1*MID(A2,3,100),A2)
1* is used to convert text into number and 100 is used to be much too long to cover any length of VAT number
AFAIK - if there are letters, it is always 2-leter, so simple formula would be:
=IF(CODE(A2)>=65,1*MID(A2,3,100),A2)
1* is used to convert text into number and 100 is used to be much too long to cover any length of VAT number
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks