In his sample data he doesn't appear to be including the last digit to the
right but rather the 6 digits to the left of the last number.

"Gary''s Student" wrote:

=right(A1,6)
--
Gary's Student


" wrote:

I am looking for a way to remove extra charaters from a number, and
copy it to a new column. Column B is generated from column A. For
example:
A = B
11005656552 565655
11004567754 456775
13117896432 789643

Thanks for you help!