Is there a formula that can do this??

[wanzek1]

I am wondering if there is a like or similar formula that I can use for this.

I would like to compare 2 different strings. One of the strings comes out as a default format from our system. It looks like this:

830. (there are 2 spaces before the 8)

This field is something that is entered manually. It has no leading characters and no trailing decimal:

830

I would like a formula that says if 830 is like 830. then use the department number that is setup within our software.

Is this possible?

Thanks!

 

[kray4660]

Use the trim function.