Suppose you had a list of addresses coded like this: 00014 SOUTH ST That you’d prefer coded like this: 14 SOUTH ST If you were addicted to modifying things programmatically in Excel, like I quite guiltily do, you could do this in MS Excel. =(MID(A1,1,FIND(” “,A1)-1))*1 & MID(A1,FIND(” “,A1),LEN(A1)) Everything before the ampersand (&) uses the =mid() function to grab everything up until the first … Continue reading Spreadsheet Fun– Excel