| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove convert/extract the number from'12345.56; ie remove ' sign | Excel Worksheet Functions | |||
| How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
| Remove ÿ | Excel Discussion (Misc queries) | |||
| remove #DIV/0! | Excel Worksheet Functions | |||
| remove an add in from xla | Excel Discussion (Misc queries) | |||
Linear Mode
