Hi all
I have hundreds of codes which I need to round down in order to get a VLOOKUP table to recongise them
Codes are P.AT000269.01 etc etc.
Any ideas please on how to get them to P.AT000269
Ie drop the .01
Would be really grateful for any idea rather than spend hours deleting .01 from each code
Many thanks for any help and your time
Regards
Mike
---------- Post added at 16:10 ---------- Previous post was at 15:49 ----------
Ah
Found it
=LEFT(A1,LEN(A1)-3)
Mike