Formula to Cut and paste Last 5 Digits into another cell

A Rose
A Rose ✭✭✭
edited 09/02/20 in Formulas and Functions

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!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!