CTRL+F doesn't work
 

Hi,
I have an excel spreadsheet that pulls sales order information (through MS
Query) from a client's accounting system. One of the cells then concatenates
two cells together to generate a unique value of the Customer Account Number
& Product Number

The formula used is, for example, =TRIM(A2&H2) & this is in AA2

I use the TRIM function to remove any extraneous data

So, in, AA2 is the value of HIL0015254 where HIL001 is the customer (in A2)
& 5254 the product code (in H2).

Now, if I do CTRL+F & search for HIL0015254, I receive an error message
sayng that the value can't be found.

Any suggestions?

Cheers
Colin Foster

CTRL+F doesn't work
 

Click on the Options button on the Find dialog (if you don't see the options)

Then change the Look in: option to Values

I'm guessing you have either Formulas or Comments in that option.


Colin Foster wrote:

Hi,
I have an excel spreadsheet that pulls sales order information (through MS
Query) from a client's accounting system. One of the cells then concatenates
two cells together to generate a unique value of the Customer Account Number
& Product Number

The formula used is, for example, =TRIM(A2&H2) & this is in AA2

I use the TRIM function to remove any extraneous data

So, in, AA2 is the value of HIL0015254 where HIL001 is the customer (in A2)
& 5254 the product code (in H2).

Now, if I do CTRL+F & search for HIL0015254, I receive an error message
sayng that the value can't be found.

Any suggestions?

Cheers
Colin Foster

--

Dave Peterson

CTRL+F doesn't work
 

Dave,

Thanks for this that sort of sorted it :-)

The Find now works in Excel, the problem is that's just an intermediate
stage & I'm then accessing the Excel database from another program & it was
that, initially, that couldn't find the value (which also, couldn't be found
through CTRL+F). So, the second part (CTRL+F) now works, I just need to sort
the other part

Regards
Colin

"Dave Peterson" wrote:

Click on the Options button on the Find dialog (if you don't see the options)

Then change the Look in: option to Values

I'm guessing you have either Formulas or Comments in that option.


Colin Foster wrote:

Hi,
I have an excel spreadsheet that pulls sales order information (through MS
Query) from a client's accounting system. One of the cells then concatenates
two cells together to generate a unique value of the Customer Account Number
& Product Number

The formula used is, for example, =TRIM(A2&H2) & this is in AA2

I use the TRIM function to remove any extraneous data

So, in, AA2 is the value of HIL0015254 where HIL001 is the customer (in A2)
& 5254 the product code (in H2).

Now, if I do CTRL+F & search for HIL0015254, I receive an error message
sayng that the value can't be found.

Any suggestions?

Cheers
Colin Foster

--

Dave Peterson