1ExcelUser
New Member
- Joined
- Oct 25, 2013
- Messages
- 5
Hi, I would like to remove some digits from a string of numbers. The numbers are always 17 digits and I would like to have certain numbers removed. For instance, if the number was 1XSFZ8ET6BKE57365.
I would want to keep the first 8 digits erase the 9th keep the 10th and 11th and remove the rest.
So 1XSFZ8ET6BKE57365 would translate into 1XSFZ8ETBK.
The list of numbers would be in column A and the results could be in any column to the right.
Any thoughts?
Thank you,
1ExcelUser
I would want to keep the first 8 digits erase the 9th keep the 10th and 11th and remove the rest.
So 1XSFZ8ET6BKE57365 would translate into 1XSFZ8ETBK.
The list of numbers would be in column A and the results could be in any column to the right.
Any thoughts?
Thank you,
1ExcelUser