I am looking for a syntax or function wherin i can replace all lines in different cells containing specific string or text in it.
e.g. Few cells in sheet contains " This guy is for deployment", other few cells may contain "guy is for core deployment" and other cells may have " project is specific deployment". I want to replace all such lines which contain a word "deployment" with ony one word "Deployment"..... Any clue???