I just need a code or function that will delete unnecessary characters.
I have a list of part numbers in a column that should be in the form of XX-XXX-XX...for some reason the database sometimes adds characters to the end. I just want to trim off any characters once you get past XX-XXX-XX (9 characters)
Maybe in a helper column...
=left(a2,9)
copied down
This assumes you want the 1st 9 characters
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Perfect thanks!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks