extracting adat

[Alex]

Hi I have a field with data as per sample:
02075157471OR02075389326

The length of the data may vary
Is there a way to extract all the data including and to the right of the
word OR

thanks
A

 

[Ken Snell \(MVP\)]

TheData = Mid(FieldName, InStr(FieldName, "OR"))