the error of "formula too long" comes because the field length is very
large (2000 characters)

therefore only solution is to make a vb macro to find and replace. can
you please make me small macro.
help will be greatly appreciated.

thanks