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

  • Thread starter Thread starter Enrico
  • Start date Start date
E

Enrico

How can I remove the txt from BAR070 in a formula so it leves only the 070 ?
 
Hi Enrico,
Suppose that is in cell A1 in cell B1 enter
=right(A1,3)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Imposs? Speed up 1
Very slow using SaveAs in Excel (and other Office apps) 2
Dlook up on continiouse form 1
leve chart 5
I know a site: Free Csharp ebooks can solve your problems easily! 1
a lot of free ebooks for DotNet maybe solve your problem. 2
excel dropdown question 4
Find your solutions with real Free eBOOKS! 2

Back
Top