I have a field which somtimes includes two words and I only need the first word. I can use this to show only the first word:
Group1: Left$([Group],InStr(1,[Group]," ")-1)
But when I use it I get #ERROR for all of the fields that only have one word. How do identify the field has one or two words so I can skip if it only has one word?