There is a Substitute function in FileMaker. You can use it in a calculated Replace Field Contents but be very careful. Make a backup first in case there is a mishap. Also note that the Substitute function is Case sensitive.
Trim ( substitute ( description ; brand ; "" ) )
This worked perfectly!