THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 35 of 50

Take your time. Find what helps.
Editorial illustration for Remove account numbers and personal details before sharing a sheet
Spreadsheets 4 min read

Remove account numbers and personal details before sharing a sheet

A checklist of places personal data hides in a statement spreadsheet, plus a masking formula, so you can share the sheet without exposing account numbers.

Read article
Editorial illustration for Remove commas from amount text with SUBSTITUTE and VALUE
Spreadsheets 3 min read

Remove commas from amount text with SUBSTITUTE and VALUE

Remove commas from amount text in Excel with SUBSTITUTE and VALUE, including Indian-grouped figures like 1,23,456.78, and why Find and Replace can bite.

Read article
Editorial illustration for Remove duplicate rows after merging two statements in a sheet
Spreadsheets 4 min read

Remove duplicate rows after merging two statements in a sheet

Remove duplicate rows after merging two bank statements in a sheet: build a key from date, amount, narration and balance, then use Remove Duplicates or UNIQUE.

Read article
Editorial illustration for Remove duplicate transactions when statement periods overlap
Spreadsheets 4 min read

Remove duplicate transactions when statement periods overlap

Remove duplicate transactions when two statements overlap, using a date, amount, balance and narration key plus an occurrence counter that keeps repeats.

Read article
Editorial illustration for Remove footer totals and disclaimer lines from a statement sheet
Spreadsheets 4 min read

Remove footer totals and disclaimer lines from a statement sheet

Find the last real transaction row in a statement sheet and remove totals, summaries and disclaimer text below it, using filters or Power Query.

Read article
Editorial illustration for Remove account-details rows above the transaction table in Excel
Spreadsheets 4 min read

Remove account-details rows above the transaction table in Excel

Delete the account-details and blank rows above a bank statement transaction table in Excel, or skip them with Power Query, to leave one clean header.

Read article
Editorial illustration for Remove long reference numbers from narration text in Excel
Spreadsheets 4 min read

Remove long reference numbers from narration text in Excel

Remove long reference numbers from bank narration text in Excel so the same merchant looks identical across rows, using Power Query, a 365 formula or Flash Fill.

Read article
Editorial illustration for Remove repeated header rows from a multi-page PDF statement in Excel
Spreadsheets 4 min read

Remove repeated header rows from a multi-page PDF statement in Excel

Remove the repeated header rows from a multi-page PDF statement in Excel with a Date filter, or with a one-step Power Query filter.

Read article
Editorial illustration for Remove the rupee symbol or INR from amount cells before summing
Spreadsheets 4 min read

Remove the rupee symbol or INR from amount cells before summing

Remove the rupee symbol or INR from amount cells in Excel with SUBSTITUTE or Find and Replace so SUM works, and when a number format is better.

Read article
Editorial illustration for Remove a fixed prefix like UPI/ from narrations with SUBSTITUTE
Spreadsheets 4 min read

Remove a fixed prefix like UPI/ from narrations with SUBSTITUTE

Remove a fixed prefix like UPI/ from narrations with SUBSTITUTE in Excel, including a nested example for five prefixes and why REPLACE by position is brittle.

Read article
Editorial illustration for Rent vs buy comparison sheet in Excel using your own inputs
Spreadsheets 4 min read

Rent vs buy comparison sheet in Excel using your own inputs

A rent vs buy sheet in Excel with every assumption in a labelled cell: the same monthly budget either pays an EMI or pays rent and invests the rest.

Read article
Editorial illustration for Rent deposit and move-in expenses tracker sheet for a new tenant
Spreadsheets 4 min read

Rent deposit and move-in expenses tracker sheet for a new tenant

Record rent deposit, brokerage, agreement charges and set-up costs in a tenant move-in sheet, with a refundable column to follow the deposit to move-out.

Read article