Can't get the right formula function.
Hi everyone,
I have text placed in A1 which is then I need to make some changes using
formula placed in A2. I've tried using Substitute and Replace but still
can't get the best result. Does it need a special functions to handle
formula? The table referrence located within range(A5:B11). The following
are an examples for these situations:-
A B
The quick brown fox jumps over the lazy dogs.
=The big fat cat jumps over the lazy monkeys.
fox cat
foxs cats
dog monkey
dogs monkeys
brown fat
quick big
Any help are appreciated.
Hopefully,
Jaemun.
|