A contact import includes aLICE kING or good MORNING; you want consistent word capitalization without manually retyping entries.

Use it when you want to:

• Clean up mixed-case first and last names for a review sheet.
• Make ordinary English labels consistent in exported reports.
• Generate word-case previews before deciding whether to replace original source values.

=PROPER(Text)

Text (required): a text constant, cell reference or formula result to convert. The official 2026 function entry documents exactly one argument and no optional arguments.

Required/optional arguments: one required text argument; none optional in the official 2026 signature. Default values: none. Text literals must be placed in double quotes; plain A1-style references refer to cells. Outputs are text, not a change to the input cell.

Function spelling: function names appear in English in the cited English-language documentation. The examples use formula syntax shown there. Because these three functions have only one argument, comma-versus-semicolon function-argument separators do not arise in their standalone formulas; formula names, locale details and separators for other functions may depend on the installed language/region and must be checked in your PlanMaker edition.

Create a new PlanMaker workbook. Type Source text in A1 and Formula result in B1. Enter the following values in the specified A-column cells, then enter the B-column formulas. Sample text has been chosen to avoid unverified accent/Unicode and punctuation-based word-boundary cases.

Enter =PROPER(A4) in B4. With aLICE kING in A4, the independently calculated expected result is Alice King.

Reproduce: after filling the A cells, enter the formula in the matching B cell and press Enter. If you copy a formula down, verify its automatically adjusted relative cell reference. Inputs can also be given directly as quoted text.

Validation disclosure: results above are expected, not observed within PlanMaker. Independent calculation used ASCII string operations in Python; it is neither the PlanMaker calculation engine nor a claim of native testing. Vendor example behavior was checked against official documentation. Exact installed-version behavior still needs owner testing.

1. Normalize a mixed-case greeting

Formula: =PROPER("GoOd MoRnInG")

Expected result: Good Morning. The official SoftMaker guide explicitly documents this class of example.

2. Apply a nested text transformation

Formula: =PROPER(LOWER(A4))

Expected result: Alice King. The LOWER result is alice king; PROPER capitalizes the beginning of each word.

3. Correct all-capital common words

Formula: =PROPER(A5)

Expected result: Iphone. For simple ASCII word input, PROPER changes IPHONE to Iphone—illustrating that branded capitalization such as iPhone may be lost.

• PROPER is not safe for every personal name, acronym or brand (e.g., custom casing, all-caps abbreviations, or iPhone). Inspect results before replacing imported values.
• SoftMaker describes word boundaries generally; punctuation, apostrophes, underscores, nonbreaking spaces, and Unicode cases were not natively tested here.
• PlanMaker/Excel cross-compatibility should be tested for non-letter separators rather than inferred from simple space-delimited English examples.
• PROPER changes letters in its output; it does not correct spelling or remove repeated spaces.
• If the software displays a syntax or name error, check the function name, leading =, matching parentheses and quotation marks. No specific error-code result is asserted without native execution.
• If a referenced input already contains a spreadsheet error, the result should not be treated as independently validated here; reproduce this edge case in the actual version before documenting a definite error outcome.
• If text changes visually but your original cell looks the same, remember formulas return into their own cells. Review carefully before using paste-as-values to replace source data.

• PlanMaker 2026 (English help): documents PROPER(Text) and the core behavior described here. Source: PROPER official 2026 reference, accessed 2026-10-11.
• PlanMaker 2024 (English help): official PROPER reference was checked for its signature and basic example; accessed 2026-10-11.
• PlanMaker 2021: Official PlanMaker 2021, 2024 and 2026 PROPER pages show the same signature and the same three illustrative greetings. Mobile/edition-specific behavior remains unverified.
• Excel: Excel also documents PROPER for capitalizing word initials; compare using ordinary ASCII words first. Its word-boundary rules around punctuation may differ, and parity is not established by the official PlanMaker short description.
• Platforms/editions: This research concerns the 2026 desktop English help reference; availability in Windows, macOS, Linux, Android/iOS or particular product editions was not tested. Official documentation membership is not proof of runtime parity in every platform.
• File formats: Do not assume behavior on conversion to legacy formats (.xls), XLSX interoperability or formula-preservation for every edge case; those scenarios require actual save/reopen comparison.

• LOWER — convert letters to lowercase (official 2026 SoftMaker help; checked 2026-10-11).
• UPPER — convert letters to uppercase (official 2026 SoftMaker help; checked 2026-10-11).
• PROPER — capitalize the beginning of words (official 2026 SoftMaker help; checked 2026-10-11).

• SoftMaker PlanMaker — function documentation
• PROPER reference
• LOWER — convert letters to lowercase
• UPPER — convert letters to uppercase
• SoftMaker PlanMaker 2021 — PROPER

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in SoftMaker PlanMaker.

• No genuine SoftMaker PlanMaker screenshots are included; this guide does not use mock application images.