copy paste last 12 digits from the specific cell

Hello,

I have a column with different bar codes scanned. Only FedEx has some 30 digits, so i need the formula that will look for 30 digits in a cell and copy past last 12 digits to the adjacent column.

I know how to use the "RIGHT" formula, but dont know how to tell it only for the cells containig 30 digits.

thasnk a lot!

Find more posts tagged with

Parsing

Accepted answers

Carson Penticuff

If you create a new column and use this formula there, it will give you the last 12 digits if the cell is 30 digits long, and will copy over the data from the Tracking Number column if it is anything other than 30 digits.

=IF(LEN([Tracking Number]@row) = 30, RIGHT([Tracking Number]@row, 12), [Tracking Number]@row)

All comments

Carson Penticuff

This would be the general idea:

=IF(LEN([Barcode Column]@row) = 30, RIGHT([Barcode Column]@row, 12), "")

Vuckecucke

for some reason when i convert f-la to column it delets exsisting barcodes.

Carson Penticuff

Can you post a screenshot of your sheet? I don't think I am understanding exactly what you are trying to do.

Vuckecucke

If i scan fedex here it will give me 30 digits- that are useless, since they use only 12 for tracking number, so i need to eliminate first set of 18 digits and have the rest in either this column, or the cadjacent column.

Carson Penticuff

=IF(LEN([Tracking Number]@row) = 30, RIGHT([Tracking Number]@row, 12), [Tracking Number]@row)

Vuckecucke

its working! thanks a lot.

Carson Penticuff

Happy to help!

Vuckecucke

thanks !

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.