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
Date
Votes
1 comment
-
Jet Reports Historic Posts I'm not sure if this is what you are after.
Lets say the jet formula that gives the full description is in F7. This formula will give the first two words, presuming that only a space is seperating the words:=LEFT(F7,FIND(" ",F7,FIND(" ",F7)+1)-1)
Is that even close to what you are after?
Please sign in to leave a comment.