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
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
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.
Thanks.