drfernandombbs
New Member
- Joined
- Dec 5, 2013
- Messages
- 10
I have several thousand rows of data and all of the rows are full of random things, but each cell contains a 15-digit account number that begins with "40". I need to show, in another cell, just the last 4 digits of this string.
I've been trying to use a FIND formula within a RIGHT formula, but can't seem to get it.
Any help is appreciated.
I've been trying to use a FIND formula within a RIGHT formula, but can't seem to get it.
Any help is appreciated.