VBA Searching Certain Number Formats, or String Function?

[ChompGator]

Hey,

Im building an excel document that uses VBA. What Im trying to do currently, is build the sheet so it can look for a certain sequence of numbers.
The numbers are either written like this
1-2-056-12 W5 or like this
01-02-056-12 W5 ....The problem is this:
There are four columns in my spreadsheet Company | Primary | UWI | Date
These numbers are in the sequence shown above, and the numbers area in the "Primary" column, they need to be taken out of the primary column and moved into the "UWI" column, but instead of going through thousands of lines is there a function or a VBA code that can search throw the primary column and pull the numbers out of the primary column and put them into the UWI column?

The reason I cant just copy the primary column and paste it into the UWI column is because there isother data in the primary column .

Any help would be appreciated, thanks!