Formula to Cut and paste Last 5 Digits into another cell
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!
Help Article Resources
Check out the Formula Handbook template!