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!

Find more posts tagged with

Accepted answers

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)

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.