All of my part numbers start with 7 digits. Some continue with a dash(-) and up to 4 additional characters. I have a vendor that does not include my dash, plus they add 4 characters to the front of my part number. I used some LEFT,MID and LEN formula's but could not get it correct. Here is an example of what I start with and how I need it to end up. Thank you!
Please try this formula
=IF(LEN(A2)=11,MID(A2,FIND("-",A2)+1,7),MID(A2,FIND("-",A2)+1,7)&"-"&RIGHT(A2,LEN(A2)-11))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Perfect Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks