Thread
:
Text
View Single Post
#
1
Dava Sutts
Posts: n/a
Text
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?
Reply With Quote