i want know How many lines begin with number(0,1,2,3,4,5,6,7,8,9) and i have next criteria other paraghaph dont write Present or begin with 1 or 2.

Thank you ver muchenter link [description][1] here

New contributor
Petr Suchánek is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Please take the time to read this – cybernetic.nomad Jul 12 at 15:01
  • 1
    With the help of Google Translate, I figured out the link was a download site. People are hesitant to download unknown files, and many sharing sites do not keep the file available permanently, in which case the question would be too ambiguous to be useful. Please post a screenshot. Thanks. – fixer1234 Jul 13 at 4:45

Suppose your lines are in Column A, starts from Cell A2.

Enter formula in Cell B2 =left(A2,1).

Copy formula B2; down the column B from B3,B4,B5...etc.

SO you will get the first digit of the Sentences in Column B.

Sort the data on Column B

Keep only rows where in Column B it is 1 or 2.

Rest can be delted.


Your Answer

Petr Suchánek is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.