in column b put this formula
find(a1,"BO",1)
in column c put this formula
mid(a1,1,b1-1)

format the c column to numbers

"Dava Sutts" wrote:

In Cell A1,2 ,3 ect i have the following info

12345BO
1234BO
123456BO

How do i convert these in Cells B1, 2, 3 etc to :
012345
001234
123456

To create a 6 figure number with the BO dropped off?