We import the master data report into a new, 3rd party system. The prior system took the property address as one field, whereas the new one has it broken up by property address, city, state, and zip. We can utilize the text to column tool in excel to separate out the state and zip since they are delimited by a comma. However, we aren't able to do the same between the property address and city.
Created By Emily Kung (Account Management)
RequesterRequested by VP of Finance & Ops:
We import the master data report into a new, 3rd party system. The prior system took the property address as one field, whereas the new one has it broken up by property address, city, state, and zip. We can utilize the text to column tool in excel to separate out the state and zip since they are delimited by a comma. However, we aren't able to do the same between the property address and city.
0 Votes
0 Comments
Login or Sign up to post a comment