How can I remove the txt from BAR070 so it leves only the 070

Enrico · Dec 1, 2008

How can I remove the txt from BAR070 in a formula so it leves only the 070 ?

Eduardo · Dec 1, 2008

Hi Enrico,
Suppose that is in cell A1 in cell B1 enter
=right(A1,3)