"BT Bill" wrote in message
...

when I applied the macro to entry eleven, it simply
replicated the values of the first ten.

This happens when your code uses absolute references rather than relative
references. If you have:

Range("A1") = 1

, you get 1 in A1. But

ActiveCell = 1

gives you one in the cell that's selected when you start the code.

If you used the macro recorder, try again. When the "Stop Recording"
toolbar's visible, notice that it has a "Relative Reference" button. When
you click this, everything you do from then on is recorded in relative (to
the active cell) mode -- until you click it again (it toggles on & off).

Post your code here if you wish ; ultimately, you'll need something *like*:

For Each Cell In Selection
Cell.Value = Right(Cell, (Len(Cell) - 2))
Next Cell

Rgds,
Andy