Pages tagged “text”

5 pages in Cellwise.

1. Auto-number invoices (INV-0001, INV-0002) with a formula

   Generate invoice numbers that count up as you fill in rows, with leading zeros.

   invoice text freelancer

2. Extract the domain from an email and a trailing number from text

   Two text formulas: the domain after the @, and a number at the end of a cell.

   text cleanup email

3. Join first, middle and last name without extra spaces

   TEXTJOIN skips blanks so names join cleanly; TRIM option for older Excel.

   text textjoin names

4. Split first and last name in one cell

   Formulas that take the first and last word from a full name, including a middle name.

   text cleanup names

5. Sum if a cell contains text (wildcards)

   SUMIFS with asterisks to total rows whose text contains a word.

   sumifs wildcards text

All pages