I promise I'm going to get better at this formula stuff, I'm just not very good with it at this point.
I have a description field in a report that the customer puts their own Change Request Number or Identifying number in the field first, with a space after, then types in the description of the change. I need to pull only that first number so I can insert it into the top of the form. For example, on this field:
AJFA4-09-257 NexGen Rearchitecture - Stand up the new infrastructure at ACT
I need to pull just that first number up to the space before the word "NexGen". I know there's a way to do this but for the life of me I can't remember how. Again, I'm sure there's a simple way but I'm stumped at the moment.
Thanks very much for all your help.