Excel Tips

Run-time error 1004 is Excel’s general refusal: VBA asked Excel to do something with a range, a sheet or a

When an Excel macro that used to work suddenly stops, the cause is usually outside the code. Something around it

To format phone numbers in Excel all the same way, strip each one down to its digits, drop a leading

To split an address such as “1200 Maple Grove Ln Apt 4B, Springfield, IL 62704” into four columns, count the

To find invalid email addresses in Excel, put a check formula beside the column and filter for FALSE. In Microsoft

To convert a quote to an invoice in Excel, build the invoice from the quote instead of retyping it: one

To track overdue invoices in Excel, keep payments in a table of their own, and let formulas work out each

To charge sales tax on parts but not labor in Excel, mark every invoice line Taxable, Yes or No, and

To invoice materials and labor in Excel, put them on the same invoice as separate lines. Price each material from

To add a button that runs a macro in Excel, go to the Developer tab, click Insert, and choose the