I have data (from a very large spreadsheet) that has data as shown below in various columns. The data should be as in col A but there is a lot of it in different formats as in B. Is there any way to change the data from B into a new column say E where I can get the data into a leading number of 3 digits, the text with 1 or 2 letters and the remainder into 4 digits with the final text subscript if it is there? Sorry but it looses format a bit here but you will get the picture.

Thanks in advance

Bill

A B

008D0013 08D13
008D0006 08D6
008D0092 08D92
008EJ0002 8 EJ 2
008EJ0003 08EJ3
008EJ0004A 8EJ04A
008EJ0004B 08-EJ-4B
095D0061 95D61