Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
599 guides · Page 35 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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