|re: "how can i make them identical format?"|
Since I can't see your spreadsheet from here, I can't answer that.
Obviously, you have to determine what is different. A leading space? A trailing space? A non-printing character? The possibilities are numerous.
One possible way to find the difference is as follows:
Put the ID from the email in A10
Put the ID from your list in A11
Put this in A1 and drag it across Row 1
=MID($A$10,COLUMN(),1) = MID($A$11,COLUMN(),1)
This will compare each character in the 2 strings, one by one, returning TRUE where they match and FALSE as soon as something different is found.
The COLUMN() function is used to determine the start_num for the MID() function. 1, then 2, then 3, etc.