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)