Hi guys! I'm new here. But I have a really mind numbing question that may be really easy to you all.
I have a string of "Names" that I need to extract the first word from (which was easy), but I also need to extract the last few words AFTER that point.
For example:
Red Box Underwear
I used the following to extract the "Red":
Left([Names],(InStr(1,[Names]," "))-1),"")
How do I extract the rest of the wording ("Box Underwear")to another field??
I have a string of "Names" that I need to extract the first word from (which was easy), but I also need to extract the last few words AFTER that point.
For example:
Red Box Underwear
I used the following to extract the "Red":
Left([Names],(InStr(1,[Names]," "))-1),"")
How do I extract the rest of the wording ("Box Underwear")to another field??