extracting adat

  • Thread starter Thread starter Alex
  • Start date Start date
A

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extract 3 numbers from a string 0
Returning Partial Strings 3
Formula to extract only numbers and decimal 2
Extract part of text 5
Using Left to extract info 1
query to get max year 2
Extract first part of text string 1
extracting data 4

Back
Top