I need to have two columns of part numbers, one part number with a straight, unbroken 12-digit string (ie. 444455556666), and I need the other column to insert dashes between every fourth digit (i.e. 4444-5555-6666). I'm pretty sure this needs to be done with VBA, but I'm a bit rusty with VBA. I already have the initial column of unbroken digits, I just need to create a new column with the inserted dashes. Thanks in advance.
hi BYizz, welcome to the forum. assuming your data is in A1, wont this work for you?
=LEFT(A1,4)&"-"&MID(A1,5,4)&"-"&RIGHT(A1,4)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Alternate,
Or just fomat A1 with the custom format: "0000-0000-0000" (no quotes)
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Originally Posted by benishiryo
This is what I ended up using; I just wasn't aware of the left mid and right text functions. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks