Hello,
one of our users ( using excel 2000 )is creating a contact list, she is getting extra figures in the id field, eg..100, 101, 1102, 103,1104 you get the picture. I've never seen this, can't find anything on the mskb yet..thanks, joe
I'm a little fuzzy on how those ID's are being inputted. Do you get these extra characters from an import file of some sort? Formula? If you can tell us how that ID field is being generated we might be able to Sherlock a preventive approach to solving the problem.
If you're looking for a way to clean the data "after the fact" I suppose you could use a formula similar to this:
=Right(A2,3) (to get the last 3 characters). I'm guessing somewhat based on your example of: <eg..100, 101, 1102, 103,1104> that 1102 is meant to be 102.
You may have to tweak the formula with an if-statement when you get ID's that are supposed to be >1000 or if you get more than an occasional extra "1" in the front of your data.
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.