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

Shows Seen: 31

DMB Hub Stubs: 10

My Tour Central Stats

Re: Excel Help

Quote:
Originally Posted by DIDriveOut2SPAC View Post
is their a quick way to alter the formatting of specific information in a column? For instance adding spaces as such:



Before:
12345-06
12345-07

After:
12 34 56-06
12 34 56-07


Greatly appreciated if you can help out!
Is the data all uniform as in your example (5 characters, a dash, followed by 2 more)?
BTBaboon is offline   Reply With Quote