Oh this looks so simple ... I have a field which contains a complete sentence but the very first word is a code ABCDDD (could be text or numbers) then a space then the sentence starts. I want the sentence only.

I tried LeftWords(field, 1) + 1. I tried RightWords(field) - LeftWords(field, 1)

Good grief. Why is this so difficult for me. I searched LeftWords and got a bunch of examples but none exactly like what I need. I want a calculation that gives just the sentence portion. My mind swims with Position, Pattern Count, MiddleWords, etc and I end up totally blank. I don't like text functions.

I decided instead of wasting another five hours just to (again) admit I don't understand how to do it, I'd post. I hope that is alright with you all and I apreciate any help.

Pete

Right( field, Length(field) - Position( field, " ", 1, 1 ) )

or

RightWords( field, WordCount(field) - 1 )

should work, although the second one will ignore any ending punctuation.

Hi Queue!

I used your second one because it actually made sense to me. It was perfect (of course).

And yes, I'm working on my text-function learning disability ...

Pete

It takes practice to learn how they all work. I still get lost in them myself sometimes, especially when I'm analyzing Ugo's solutions. So don't feel too bad about it.