Exact Match

  • Thread starter Thread starter Leo Fredette
  • Start date Start date
L

Leo Fredette

I have searched for an answer to no avail..

Here is the sheet:

A1 N1
ID ID
I12345 I12345

They were imported using the Import External Data from a csv file (there are
other fields I am also trying to match)..I used the general setting during
the import

If I use the following expression in J1
=EXACT(A1,N1)
It returns a false, when they look exact except for the fact that I imported
from a csv file...if I retype each one in excel, it will return a true..

Does anyone know the reason and/or a solution?

Leo Fredette
 
Leo
A problem with data that is imported is that sometimes you get
extraneous spaces with the data. The space cannot be seen by you and me but
it's a character, just like any other character, to Excel.
Use the Trim function in another column to remove extra spaces. If your
data is in Column A and column B is available, then in A1 put "Trim(A1)"
without the quotes. Drag this formula down as far as your data goes. Then
select all the entries in Column B, do Edit-Copy, then select A1 and do
Edit - Paste Special - Values. HTH Otto
 
I will try this..

Leo

Otto Moehrbach said:
Leo
A problem with data that is imported is that sometimes you get
extraneous spaces with the data. The space cannot be seen by you and me
but it's a character, just like any other character, to Excel.
Use the Trim function in another column to remove extra spaces. If
your data is in Column A and column B is available, then in A1 put
"Trim(A1)" without the quotes. Drag this formula down as far as your data
goes. Then select all the entries in Column B, do Edit-Copy, then select
A1 and do Edit - Paste Special - Values. HTH Otto
Click to expand...
 
Back
Top