Thanks, you have saved me a load of time.

"tjtjjtjt" wrote:

One way (if you don't need the letters at all anymore):
Make ure there are blank cells to the right of thses cells.
Select the cells
Go to Data | Text to Columns
Choose Delimited and click Next
Set B as the Delimiter
Click Finish
You'll end up with the Numbers in their original cell, the B will be gone
and the O will be in a cell to the right. You can delete the extraneous O's.

Then, with your number cells Selected:
Format | Cells
On the Number Tab Choose Custom
Type 6 consecutive zeroes (000000) in the line provided. Don't use the
parentheses. This will give you the number format you typed out below.

tj


"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?