Excel – how to separate first name and last name from a full name
How can I separate first and last name from a full name in Excel? Learn how to use Excel formulas to extract the first and last name from a column…
formula
Crystal Reports – How to apply conditional formatting to fields
How to Apply Conditional Formatting in Crystal Reports - A step by step guide with examples. Learn how to format fields based on conditions using formulas in Crystal Reports.
Excel 2013 – How to start new paragraph in a cell (add a line break)
Learn how to create a new paragraph within a cell in Excel 2013 by pressing Alt + Enter while in the active cell.
Crystal Reports – ‘Sum’ option and Number formatting missing
This article discusses a solution to fix the issue where the 'Number' tab and 'Sum' option are missing in Crystal Reports while working with a field containing numbers in an…
Excel 2010 – how to view all locked cells
Learn how to easily view all locked cells in an Excel 2010 spreadsheet using conditional formatting.
Crystal Reports – Remove decimal places from string
How to Remove Decimal Places From a String Number in Crystal Reports
Word 2010 – Calculations using mail merge fields
Learn how to perform calculations with mail merge fields in Microsoft Word 2010 using our step-by-step guide.
Crystal Reports – Prompt for value, if empty use database
Learn how to create a Crystal Report that prompts for a value and uses a formula field to select the alternative value from the database if it's empty.
Crystal Reports – If field is empty select another field
The article provides instructions on creating a Crystal Report that selects an alternate field when the primary field is blank or null, specifically for databases with inconsistent data such as…