I have a file from Lexis Nexis batch services of best addresses I need to import into RE. They have put the +4 in a separate column and the file is in excel so it has stripped the leading zeros (so not helpful excel!) that makes it virtually impossible for me to use the concatenate function to pull the two columns together and get the dropped zeros in the right place in the file. I tried using custom cell formats to put the leading zeros in, then concatenate, and then copy and paste just the values; apparently the custom format isn't recognized as a value so it drops the zeros again. Sigh. Is there a dictionary out there that will fix this?
Cal State, Monterey Bay