In an empty column, enter this formula (assuming your names are in column A
and all the numbers are 8 characters long)

=LEFT(A1,LEN(A1) - 8) - works if there are no spaces between the name &
numbers
=LEFT(A1,LEN(A1) - 9) - works if there is one space between the name &
numbers



"homer" wrote:

I have a column of names followed by a number. Obviously the names are of
different lengths but the numbers are consistent, so i need to remove say 8
chars from the right of each filed in the column. I'm sure I have done this
before but can't remember how! D'oh!