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?

Use Find and Replace

.* in Find
Replace with B


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551954

Maybe in a helper column use this, copied down.....

=INT(A1)&"B"

Then Copy PasteSpecial Values on the helper column to get rid of the
formulas and delete the original column if desired.

Vaya con Dios,
Chuck, CABGx3



"Shirley M." wrote:

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?

Thank you to both of you for your replies but I dont think I explained myself
properly. The replacement would not always be a B. I would have As, Bs and
Cs. Is there anyway of saying all numbers between 3.0 and 3.3 will be 3C all
between 3.4 and 3.6 would be 3B and all between 3.7 and 3.9 will be 3A Thank
you again and I am grateful for all suggestions.

"CLR" wrote:

Maybe in a helper column use this, copied down.....

=INT(A1)&"B"

Then Copy PasteSpecial Values on the helper column to get rid of the
formulas and delete the original column if desired.

Vaya con Dios,
Chuck, CABGx3



"Shirley M." wrote:

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?