If all the numbers in column A are the same length you can use this formula.

=MID(A1,5,6)

" 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!