Separating Info in Excel Combined Fields
Here’s a quick fix if you have an Excel spreadsheet that has a field that combines the city, state, and zip in one field. Three calculations will easily extract the information and place them into individual fields allowing you to easily import them into FileMaker. The combined field is present in B2 and the formula [...]