Formula to Cut and paste Last 5 Digits into another cell

A Rose

Hi there,

Is there a way to Cut and paste Last 5 Digits into another cell?

Example A1 has: 12345678, can I cut 45678 and paste into B1, using the same formula, for the entire column ?

(I know about the remove first or last digits, but is there a way to cut and paste?)

Thank you for your help!

Paul Newcome

Not necessarily a direct cut/paste for an entire column, but you can use a RIGHT function to pull the 5 rightmost characters and then cut/paste special and paste the values.

A Rose

Thank you!

A Rose

I needed to use these functions

Leave Last 5

=RIGHT(A1,5)

Leave Everything But Last 6 Digits

=LEFT(A1,LEN(A5)-6)

Paul Newcome

Not necessarily a direct cut/paste for an entire column, but you can use a RIGHT function to pull the 5 rightmost characters and then cut/paste special and paste the values.

A Rose

Thank you!

A Rose

I got it.

Thank you!

Paul Newcome

Happy to help. 👍️

A Rose

I needed to use these functions

Leave Last 5

=RIGHT(A1,5)

Leave Everything But Last 6 Digits

=LEFT(A1,LEN(A5)-6)