Text is in Column B3:B3000 range. If the length of text in cell does not =7 or =4 then delete row. Any ideas please?
Text is in Column B3:B3000 range. If the length of text in cell does not =7 or =4 then delete row. Any ideas please?
Use an extra column and the auto filter
Or place a sample file.Please Login or Register to view this content.
C3 =IF(OR(LEN(B3)=7,LEN(B3)=4),"delete","") and drag down.
After that filter on column C on delete and delete the visual rows.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks