Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 05-10-2017, 04:35 PM   #141
BTBaboon
 
BTBaboon's Avatar
 
Join Date: Jul 2015
Posts: 51,327

Shows Seen: 31

DMB Hub Stubs: 10

My Tour Central Stats

Re: Excel Help

Quote:
Originally Posted by DIDriveOut2SPAC View Post
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
BTBaboon is online now   Reply With Quote