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)
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)