Function can be used to replace character(s) with other character(s).
Inside a string formulae, the function REPLACE can be used to replace character(s) with other character(s).
The format of the function is as follows:
=REPLACE(initial string,search string,replace string)
So the following could be entered in the formula expression dialog.
=REPLACE(LAM-OAK,LAM,LAMINATE) would give LAMINATE-OAK
This example removes the spaces from the original strings and replaces them with under scores.
=REPLACE("LAM WHITE OAK",," ""_") would give LAM_WHITE_OAK
If the string to be replaced is not found the original string the formula will return the original string (unmodified).
Any text containing spaces needs to be contained within "".