How to change supporters’ address format?
US-based organizations can control how supporter mailing addresses are formatted. You can choose whether addresses are saved in Proper Case or ALL CAPS.
Change the address format
To choose an address format, you must enable mailing address validation.
- In the Dashboard, go to Settings > Supporters.
- Find the Supporter mailing address section.
- Select Validate mailing address if it is not already selected.
- Choose one of the options:
- First letter of each word capitalized
- All letters capitalized.
- Save your changes.
US address suggestions may appear in uppercase during checkout, even when you choose the first-letter capitalization option. The selected format applies to eligible saved addresses.
Format existing addresses
The setting does not reformat addresses collected before you changed it. To change the format in an export, export your supporter records and format the addresses in a spreadsheet. Changes to the spreadsheet do not update records in Fundraise Up.
For example, in Microsoft Excel, use =PROPER(A2) to change the capitalization of the text in cell A2. Review the results: the function may change the capitalization of names and abbreviations, such as McDonald or PO Box. Learn more about changing text case in Excel.