Counting digits and deleting them

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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Well a formula doing this would have to be able to map out every pattern you need. But in the example's case of "Combine the first 8 characters with the 10th & 11th characters from a string", you could use:

=LEFT(A2,8)&MID(A2,10,2)
 
Upvote 0

Forum statistics

Threads
1,223,275
Messages
6,171,126
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top