Finding cells with leading characters

G

gcotterl

My spreadsheet looks like this:

A
1 000000
2 182068
3 198506
4 200081
5 368010
6 580905
7 680001
8 686850
9 690060
10 700012
11 701068
12 802054
13 920211
14 968902

Using EDIT/FIND, when I enter '68' in the "Find What:" box, Excel
finds A2, A5, A7, A8, A11 and A14 because their values contain '68'.

What do I enter in the "Find What:" box to find the cells whose values
BEGIN with '68'? (In this example, it would find only A7 and A8)
 
K

Ken Johnson

My spreadsheet looks like this:

                 A
 1       000000
 2       182068
 3       198506
 4       200081
 5       368010
 6       580905
 7       680001
 8       686850
 9       690060
10       700012
11       701068
12       802054
13       920211
14       968902

Using EDIT/FIND, when I enter '68' in the "Find What:" box, Excel
finds A2, A5, A7, A8, A11 and A14 because their values contain '68'.

What do I enter in the "Find What:" box to find the cells whose values
BEGIN with '68'?  (In this example, it would find only A7 and A8)

68????
Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top