miamiman33176
Board Regular
- Joined
- Jan 9, 2009
- Messages
- 97
I am hoping that someone can assist me. I have lines of data that contains account number that are all 10 numerical charcters. The account numbers only show up one time in the cell and are in different locations in the cell on different lines. Is there a formula that I can use to extract a 10 digit number from anywhere in the time? There are some numbers that are more that 10 and less than ten, but I only care about the ten digit numbers that are grouped together.
Thanks.
Thanks.