I have an excel sheet where the formula to move the year in the text to the front is failing after row 12. Just need some help to determine why its failing and if it can be modified.
I had a similar post for a different column in the spreadsheet.htmlyearerror.xlsx
Your formula is seaching for "20" in the cells of Column C. From cell C12 downward, there is no 20 anywhere in the text for the FIND function to find, so the FIND function raises an error. What is supposed to happen for these cells?
How about there is no year in C12 onwards ???
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks