Before you delete the old copy all new and paste special as values in place,
then delete the old

--


Regards,


Peo Sjoblom

"capxc" wrote in message
...
Formula is succesful but when Idelete the old column, the new column shows
only
#VALUE!
How do I get to see the numbers?
--
capxc


"Fred Smith" wrote:

You don't. You do it as follows:

1. Insert a helper column, typically right next to the current one (so it
will be column E).
2. Insert the formula given in E1, and copy it down. The easiest way to
copy
it down is double click on the fill handle (bottom right hand cornet of
the
box).
3. Copy the column (highlight the top box with the E in it, right click
and
choose Copy).
4. Paste SpecialValues... (Right click anywhere in the column, choose
Paste
Special... Chose Values).
5. Delete the old column.

Regards,
Fred.

"capxc" wrote in message
...
How do i put this command?
--
capxc


"Jarek Kujawa" wrote:

=Right(A1,LEN(A1)-6)