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.
Last edited by renjithvakkayil; 01-24-2021 at 04:37 AM.
2300 rows... Quite a sample. We only need 10-20. Manual checking becomes impossible with thta number. So, this is NOT checked... You can do that bit...
=IFERROR(REPLACE(F8,SEARCH("LFT",F8),16,""),F8)
since you have Excel 2007, do you really need backwards compatability with the obsolete Excel 2003 format (.xls). I have saved the fle as .xlsx.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Sorry for the delay and thanks for the help..Will check and update you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks