I have a list of numbers in one column, e.g. 3.1, 3.4, 2.3 4.3 etc. Does
anybody know if I can replace numbers within a range with one value i.e. all
numbers between 3.1 and 3.5 to become 3B all numbers between 2.0 and 2.5 to
become 2B and numbers between 4.0 and 4.5 to become 4B, the list would then
become 3B, 3B, 2B, 4B. Is it possible to do this without going to individual
cells, similar to the find and replace function?