Replace blanks/spaces

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

Thats great - thanks you.

How do i add to the below formula to alos not innclude any that have a / in the first 11 aswell?

Thanks again