Thread: Excel question please
View Single Post
Old 31-01-2019, 16:10   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel question please
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
Mike is offline   Reply With Quote