Dear Friends I am not sure if the title is clear..I have an excel sheet with 1000s of rows and some rows have value starting with "LFT" and I have extracted the same using TRIM function (with help from google) and placed in another column.My intention was not to extract the word but to remove it entirely.So I am attaching an excel sheet and I need to remove the value mentioned in cell H2 from the cell C2.
Please let me know how to do it.
Bookmarks