don't know if this is possible with the if function but i want to enter text automatically from a downloaded file from an instrument i have got most of it to work but the instrument hes limited fields and i need to add a location field.So i was wondering if i added a numuber to the description of an item say "iron 1" "tv 2" etc when i down load it into excel could i use if to say if "1" kitchen "2" lounge ETC so basically what i want to know is can you use if function to look at a specific part of a cell ie in a cell containing iron 1 just look for the 1 and ignore the iron .sorry for being long winded