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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I remove the txt from BAR070 so it leves only the 070 (https://www.excelbanter.com/excel-discussion-misc-queries/212056-how-can-i-remove-txt-bar070-so-leves-only-070-a.html)

Enrico

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

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

Eduardo

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

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

"Enrico" wrote:

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

All times are GMT +1. The time now is 06:49 PM.