I have a spreadsheet with 2 columns A and B. In column B I want to move the last 6 digits of the part # to the right and add parentheses around those last 6 digits as I have done maually up to row 40. I have over a thousand parts and I'm trying to find a formula or macro that could be used to accomplish this goal in a timely manner. Attached a a sample of the spreadsheet. Thanks in advance for your help.
Christian
Christian