I have an Excel spreadsheet of automotive bearing part number interchange information with one column of data that I want to divide into three columns of data. The data consists of a part#, manufacturer, and Timken part#. For example "000843506 LEE .......................... 311TB." One problem is there are inconsistent rules between each data section. For instance there appears to be one or more spaces between the part# field and the manufacturer field. There is also a lot of inconsistency between the manufacturer field and the Timkin part#. It can have a series of spaces and periods of different lengths or just a series of spaces without periods of different lengths. Can someone please help me? Thank you