Jet or Excel function? Please help

I have a pretty complicated jet report (to me) and I have a field that pulls Item Category Code from Navision. Here's my problem:
my boss wants me to use only the first two words of each item category code Description. example.
Item Category Code = AC
Description = AC Adapter, Power for Laptop
I am currently bringing the entire description into the report which i use for another portion of my report. Is there a way to break apart the description into another cell and only use the First two words? I'm stumped Please help

1 comment

Please sign in to leave a comment.