Quote:
Originally Posted by DIDriveOut2SPAC
Yes for the most part.
I have some in that format with an additional -R1, -R2 for resubmittals of the same information, but they are so few I can do those ones manually.
|
Okay, so what I'd do (for this example say your column of data formatted that way starts in A2) is in the adjacent column/cell type:
=LEFT(A2,2)&" "&MID(A2,3,2)&" "&MID(A2,5,1)&"6"&RIGHT(A2,3)
See link below for screenshot of excel to see if that's what you'd like. You'll have to manually edit the formula for those exceptions; changing the last '3' in the formula to 6 to include the extra dash and 2 characters
http://i.imgur.com/oKDNBDa.jpg
Let me know if that works for you