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!
Best Answer
-
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)
Answers
-
This would be the general idea:
=IF(LEN([Barcode Column]@row) = 30, RIGHT([Barcode Column]@row, 12), "")
-
for some reason when i convert f-la to column it delets exsisting barcodes.
-
Can you post a screenshot of your sheet? I don't think I am understanding exactly what you are trying to do.
-
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.
-
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)
-
its working! thanks a lot.
-
Happy to help!
-
thanks !
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives