Replace Function



Description

Returns a string in which a specified substring has been replaced with another substring a specified number of times.

Syntax

Replace(expression, find, replace[, start[, count[, compare]]])

The Replace function syntax has these named arguments:

Part >< Description
expression >< Required. String expression containing substring to replace.
find >< Required. Substring being searched for.
replace <> Required. Replacement substring.
start <> Optional. Position within expression where substring search is to begin. If omitted, 1 is assumed.
count >< Optional. Number of substring substitutions to perform. If omitted, the default value is –1, which means make all possible substitutions.
compare >< Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values.

<SKIPED>

Remarks

The return value of the Replace function is a string, with substitutions made, that begins at the position specified by start and and concludes at the end of the expression string. It is not a copy of the original string from start to finish.

все есть по F1

А такой опции и нет.
Попробуйте поставить пробелы в конце и начале слова для поиска.
Например BBB = Replace(" kjh kjhjhg", " kjh ", " bbb ")
Получим bbb kjhjhg

Я думаю ответ очевиден.
Перед применением Replace добавьте к вашей строке пробелы в начало и конец, а затем, после замены, обрежьте пробелы.