MID Function

  • Thread starter Thread starter ACarella
  • Start date Start date
A

ACarella

I have the following
R23/24/25/26 - the then there is a text phrase
R23 - then there is a text phrase
R101/34/56 - then another text phrase

I am trying to return all the text phrases without their R Codes and cannot
figure out if I am using Mid or Left...

can anyone help me?
thank you
AMC
 
If as you posted the data always has a space, dash, and another space it is
easy --
Mid([YourField], InStr([YourField], " - ")+1)
 
Back
Top