Excel how-to guides

Split Names in ExcelFull names into first & last name columns. Remove Duplicates in ExcelDelete, flag, or merge duplicate rows. Unpivot Data in ExcelTurn a wide cross-tab into a flat table. Convert Text to Date in ExcelReal dates from text, including day-first. Extract Email Addresses in ExcelPull clean emails out of messy cells. Remove Extra Spaces in ExcelTrim and clean stray, hidden spaces. Change Case in ExcelUPPER, lower, Proper, and Sentence case. VLOOKUP Between Sheets in ExcelLook up values across two sheets. Merge Two Sheets in ExcelJoin tables by a common column. Fix Garbled Text in ExcelRepair mojibake (café → café). Transpose Data in ExcelSwap rows and columns. Compare Two Columns in ExcelFlag matches and differences. Combine Multiple Sheets in ExcelStack every sheet into one. Remove Special Characters in ExcelStrip symbols and punctuation. Split Text into Rows in ExcelExplode a cell into rows. Regex Find & Replace in ExcelMatch patterns, not fixed text. Natural Sort in ExcelItem2 before Item10, done right. Remove Accents in Excelcafé → cafe for clean keys. Convert Formulas to Values in ExcelFreeze results in place. Find Hidden Characters in ExcelWhy your lookup won't match. Fuzzy Match Duplicates in ExcelCatch typos and near-matches. Anonymize Data in ExcelMask, hash, redact, or pseudonymize. Audit Data Quality in ExcelPer-column blanks, dupes, and types. Compare Two Excel FilesFind every difference, cell by cell. Validate Data in ExcelFlag rows that break your rules. Find Outliers in ExcelZ-score or IQR, in one click. Combine Columns in ExcelJoin columns without losing data. Convert Text to Number in ExcelFix numbers stored as text. Add Leading Zeros in ExcelPad 42 to 00042, and keep it. Convert Numbers to Words in ExcelSpell amounts out, no macro. Group & Summarize in ExcelSum or average by group, no pivot. Round Numbers in ExcelNearest, up, or down — the real value. Format Phone Numbers in ExcelOne clean style, E.164 or digits. Reverse Order of Data in ExcelFlip rows or cells, no helper column. Add a Prefix or Suffix in ExcelText before or after every cell. Count Colored Cells in ExcelCount & sum by fill or font colour. Fill Blank Cells in ExcelValue above into every blank. Unmerge Cells in ExcelSplit merges and fill down. Split Data into Multiple SheetsA sheet per region, rep, or month. List All Sheet Names in ExcelA clickable table of contents. Combine Multiple Excel FilesMerge many files into one table. Delete Rows by ConditionDrop rows where a column matches. Combine a Column into One CellThe range version of TEXTJOIN. Remove Line Breaks in ExcelFlatten cells that span lines. Calculate Percentage ChangeGrowth or variance, formatted. Find All Errors in ExcelList every #REF! and #N/A. Split an Address into ColumnsStreet, City, State, ZIP. Convert Excel to Markdown, JSON, SQLPrep a table for ChatGPT or code. Batch Calculate a Whole RangeAdd, multiply, or round in one step. Convert Units in Excelkg to lb, cm to inches, °C to °F. Convert Time Zones in ExcelUTC to local, daylight-saving aware. Convert to Lakhs & Crores in ExcelIndian format; millions to lakhs. Add or Subtract Dates in ExcelDays, months, years, business days. Sort by Multiple Columns in ExcelUp to 3 keys, natural order. Cross-Tabulation in ExcelFlat list into a two-way table. Consolidate Multiple SheetsTotals aligned by label, not position. Wrap a Column into a TableWRAPROWS & TOCOL, no formula. Convert Number Base in ExcelBinary, octal, decimal, hex. Extract Unique Values in ExcelDistinct list, with counts. Add Serial Numbers in ExcelNumbered column, never drifting. Fill Blank Cells to the RightRepeat a spanning label across. Moving Average in ExcelSmooth a noisy series, trailing SMA. Top N per Group in ExcelBiggest sale per customer, top 3 per team. Split Text into ColumnsBy comma, space, or any delimiter. Extract Text from a CellBefore, after, or first/last N chars. Extract Numbers from TextPull digits out of messy cells. Remove Duplicates Within a Cella, b, a → a, b, keeping order. Remove HTML Tags in ExcelStrip tags, decode entities. Regex Extract to ColumnsCapture groups into columns. Split Fixed-Width DataMainframe & bank flat files. Flash Fill by ExampleDeterministic, runs on your PC. Bulk Find & ReplaceHundreds of pairs in one pass. Base64, URL & Hex EncodersEncode/decode offline. Clean Company NamesStrip Inc, Ltd, LLC; tidy variants. Standardize Inconsistent ValuesCluster & unify spellings. Count Characters in ExcelLength of each cell, in a column. Count Words in ExcelWord count per cell. Convert JSON to ColumnsExplode API exports into columns. Running Total in ExcelCumulative sum, no $ anchoring. Rank Values in ExcelWith standard or dense ties. Percent of Total in ExcelEach row as a share of the column. Cumulative Percentage (Pareto)Running share for 80-20 curves. Change the Sign of NumbersFix trailing-minus & (50) text. Convert % to a Number5% text into a real number. Fix European Numbers1.234,56 into a real number. Random Sample in ExcelSeeded, reproducible spot-checks. Fill a Series in ExcelContinue numbers, dates, Item 3. Fix Dates in ExcelMixed date text into real dates. Extract Year, Month, DayPlus weekday and quarter. Calculate Date DifferenceDays, months, or years (DATEDIF). Swap Two ColumnsExchange contents in place. Merge Rows in ExcelCollapse wrapped rows into one. Highlight DuplicatesFlag repeats without deleting. Merge Duplicate RowsRoll up rows sharing a key. Reconcile Two TablesAdded, removed, changed rows. Compare Two RangesEvery changed cell, listed. Fuzzy VLOOKUPMatch despite typos, with a score. Fix VLOOKUP #N/AFind & repair why it won't match. Delete Blank RowsRemove fully empty rows. Instant DashboardKPI cards & charts, no pivots. Interactive DashboardCross-filtering, Power BI-style. Explain a FormulaPlain-English breakdown. Trace Precedents & DependentsMap how formulas connect. Generate Barcodes & QREAN-13, UPC-A, Code 128, QR. Find & Redact PIIEmails, phones, cards, IDs. Insert Images from a FolderMatch photos to rows by SKU. Picture to Excel TableScreenshot or photo into a sheet.