MID Function

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
 
K

KARL DEWEY

If as you posted the data always has a space, dash, and another space it is
easy --
Mid([YourField], InStr([YourField], " - ")+1)
 

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

Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Importing data with tabs 3
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
More functional Keyword Search? 2
is there an auto complete function for words or phrases in 2007 1
Macro adjustment please! 3
Code to read file in reverse fast line by line 3
Marco is not working 1

Top