Hi,

I have pulled the first 11 characters/digits from a string of text (as im trying to find a product code that is 11 characters/digits and always at the start) problems is otehr lunes are duff infimation, but mainly have a space in the first 11 characters/digits - is there way of replacing these?

Alternativetly is there a way to say if i find two or three letters at the start of a cell, pull the data otherwise ignore it?

Plaese let me know if you need any further info?

A