Text in spreadsheets
Answer-first guides for Text in Excel and Google Sheets, each with a tool you can run. 712 topics across 88 sub-topics.
guides
How to Combine Two Columns in ExcelHow to Wrap Text in ExcelHow to Combine Two Cells in ExcelHow to Combine 2 Columns in ExcelHow to Split Cells in ExcelHow to Separate Names in ExcelHow to Separate First and Last Name in ExcelHow to Combine Cells in ExcelFind and Replace in ExcelHow to Split First and Last Name in ExcelHow to Combine Columns in ExcelHow to Mail Merge from Excel to Word
Sub-topics
Cells230
How to Use MID Text in ExcelMore Words for ExcellentExcel En WordSplitting Cells in ExcelName Manager ExcelExcel Merge and CentreRemove Specific CharacterHow Excellent Is Thy NameText Splitting in ExcelExcel Combining TextExcel Find ReplaceText Join Excel
BrowseCombine Workbooks72
Combine Excel FilesHow to Combine Excel SpreadsheetsHow to Merge Sheets in ExcelHow to Combine Sheets in ExcelCombine Multiple Excel FilesHow to Merge Two Excel SpreadsheetsCombine Multiple Excel Files Into OneCombine Multiple Excel Sheets Into OneCombine Excel Sheets Into OneHow to Combine Two Excel SheetsMerge Excel Sheets Into OneHow to Merge Excel Spreadsheets
BrowseCONCATENATE30
How to Combine Two Cells in ExcelHow to Combine Cells in ExcelCombine First and Last Name in ExcelHow to Merge First and Last Name in ExcelHow to Combine 2 Cells in ExcelCombine Text in ExcelMerge First Last Name ExcelExcel Combine Text from 2 CellsHow to Combine Text from Two Cells in ExcelMerge Text in ExcelHow to Combine Names in ExcelHow to Merge First Name and Surname in Excel
BrowseCombine Columns10
How to Combine Two Columns in ExcelHow to Combine 2 Columns in ExcelHow to Combine Columns in ExcelHow to Combine 2 Columns in Excel with a SpaceCombine Column Data in ExcelCombine Two Columns of Data in ExcelHow to Combine Two Columns Into One in ExcelHow to Combine Two Columns in Excel with a SpaceCombine Multiple Columns in Excel Into One ColumnHow to Combine Two Columns in Excel Names
BrowseSplit Text27
How to Split Cells in ExcelHow to Separate Names in ExcelHow to Split a Column in ExcelHow to Separate Text in ExcelHow to Split Data in ExcelHow to Split Text in ExcelSplit Excel Cell Into Two ColumnsSplit Excel Cell Into Two RowsExcel Split Text by DelimiterCan You Split a Cell in ExcelHow to Split One Cell Into Two in ExcelExcel Split Cell Into Two
BrowseCase Converter47
How to Change Capital Letters to Lowercase in ExcelExcel Change to UppercaseChange to Capital Letters in ExcelExcel Change Upper CaseChange Case to Uppercase in ExcelChange Uppercase to Lowercase in ExcelConverting to Uppercase in ExcelChange Upper Case to Lower Case in ExcelChange Uppercase to Title Case in ExcelProper Case FormulaHow to Change from Uppercase to Lowercase in ExcelChange to Lowercase in Excel
BrowseWrap Text16
How to Wrap Text in ExcelHow to Word Wrap in ExcelWhere Is Wrap Text in ExcelText Wrapping in ExcelExcel Wrap Text in CellWhere Is Word Wrap in ExcelWord Wrapping in ExcelExcel Wrap Text Not WorkingWrap Text Button in ExcelHow to Do Wrap Text in ExcelWhat Is Wrap Text in ExcelHow to Apply Wrap Text in Excel
BrowseSplit Names9
How to Separate First and Last Name in ExcelHow to Split First and Last Name in ExcelHow to Separate Last Name First Name in ExcelHow to Separate First Name and Surname in ExcelHow to Split Names in ExcelExcel Split First Last NameHow to Separate Last Name in ExcelExcel Split Name Into Two ColumnsExcel Extract Last Name
BrowseMail Merge Excel Word19
How to Mail Merge from Excel to WordMail Merge from Excel to Word LabelsHow to Do a Mail Merge from ExcelHow to Do Mail Merge from Excel to WordMail Merge Labels from ExcelExcel Mail MergeHow to Mail Merge from ExcelHow to Mail Merge in Excel to WordHow to Do a Mail Merge for Labels from ExcelExcel Mail Merge LabelsHow Do You Do a Mail Merge in ExcelOutlook Email Merge from Excel
BrowseFn LEFT RIGHT MID23
Excel RIGHT FunctionExtract Text Between Two CharactersExcel MID FunctionRIGHT Formula ExcelExcel Substring FunctionMID Formula in ExcelExcel Extract Text After CharacterExcel Extract TextHow to Use LEFT Function in ExcelExcel Formula SubstringHow to Use LEFT Formula in ExcelRemove First 3 Characters Excel
BrowseCOUNT Characters12
Excel COUNT Characters in CellCOUNT Characters in ExcelExcel Number of Characters in a CellCOUNT Char ExcelExcel COUNT Number of Characters in a CellExcel Function to COUNT Characters in a CellCOUNT Number of Characters in ExcelExcel Formula to Find Out Special Characters in a CellExcel Number of CharactersHow to Do Character COUNT in ExcelExcel COUNT Characters in StringCOUNT Number of Characters in a String Excel
BrowseFn CONCATENATE20
CONCATENATE with SpaceCONCATENATE with CommaExcel CONCATENATE Two ColumnsHow to Use CONCATENATE ExcelCONCATENATE DateExcel CONCAT Two ColumnsHow to Use CONCAT ExcelExcel CONCATENATE Multiple CellsCONCATENATE Columns in ExcelCONCAT Date in ExcelHow to CONCATENATE a Line Break in ExcelCONCAT Excel Columns
BrowseFind Replace8
Find and Replace in ExcelHow to Replace Words in ExcelFind and Replace Function in ExcelWhere Is Find and Replace in ExcelExcel Find and Replace WildcardExcel Replace Formula with ValueFind and Replace in ExcellExcel Find and Replace Multiple Values
BrowseSheets & Workbooks25
Excel Workbook MergeHow to Merge Different Sheets in ExcelHow to Excel Sheet MergeMerging Excel SpreadsheetsHow to Merge Different Excel Sheets Into OneRental Property Excel Spreadsheet FreeExcel Combine Data from Multiple SheetsTwo Excel Sheet MergeHow to Merge a Downloaded Spreadsheet to Another on ExcelExcel Sheet MergerInvestment Property Excel SpreadsheetHow to Select Multiple Sheets in Excel
BrowseRemove Characters6
Remove Last CharacterRemove First CharacterRemove First Character from String ExcelExcel Remove Last Character from RIGHTRemove Last Character from String ExcelHow to Remove Leading Characters in Excel
BrowseStrikethrough4
How to Strike Through Text in ExcelHow to Cross Out Text in ExcelStrikethrough Text ExcelHow to Uncross Out Words in Excel
BrowseNamed Range6
Name Box in ExcelExcel Name the RangeWhere Is the Name Box in ExcelWhat Is the Name Box in ExcelExcel Define NameWhat Is a Name Range in Excel
BrowseRows9
How to Merge Rows in ExcelCombine Rows in ExcelHow to Merge Two Rows in ExcelHow to Merge 2 Rows in ExcelHow to Highlight Multiple Rows in ExcelExcel Merging RowsCombine Two Rows in ExcelHow to Split Rows in ExcelCombine 2 Rows in Excel
BrowseColumns4
How to Show Hidden Excel Columns from LEFTExcel Splitting ColumnsHow to Combine 3 Columns in ExcelHow to Combine Data from Two Columns in Excel
BrowseCOUNT5
Counting Characters in ExcelCounting Characters in Excel CellExcel Formula Counting Characters Within a CellHow to COUNT Specific Characters in ExcelExcel COUNT Specific Characters in Cell
BrowseFn TRIM6
TRIM Function in ExcelHow to Use TRIM Formula in ExcelTRIM Words in ExcelExcel TRIM Function Not WorkingHow to TRIM Text in ExcelHow to TRIM Cells in Excel
BrowseFormulas8
Replace Function ExcelLen in Excel FormulaExcel Formula Remove All Non Alpha Numeric CharactersSplit Formula in ExcelProper Formular in ExcelWhich Character Will Always Precede an Excel FormulaCapital Asset Pricing Model Formula in ExcelClean Excel Formula
BrowseFn SUBSTITUTE4
Excel SUBSTITUTE FunctionSUBSTITUTE Multiple ValuesSUBSTITUTE Formula in ExcelExcel SUBSTITUTE Multiple Characters
BrowseMultiplication7
How Do I Do Multiplication in ExcelWhat Is the Multiplication Symbol in ExcelMultiplication Symbol in ExcelMatrix Multiplication in ExcelMultiplication Sign for ExcelExcel Multiplication SUMMultiplication Table Excel
BrowseCompare Sheets5
Excel Compare Two WorksheetsHow to Compare Two Workbooks in ExcelCompare Two Excel Worksheets for DifferencesCompare Two Excel Workbooks for DifferencesExcel Compare Two Tabs
BrowseFn LINEST4
Multiple Regression ExcelHow to Do Multiple Regression in ExcelHow to Run Multiple Regression in ExcelHow to Perform Multiple Regression in Excel
BrowseVLOOKUP4
Excel Lookup Multiple CriteriaExcel Lookup Two CriteriaExcel Lookup Multiple ValuesLookup Excel Text
BrowseWord to Excel5
Text Doc to ExcelHow to Embed a Word Doc in ExcelHow to Put a Word Document Into ExcelHow to Attach Word Doc in ExcelWord Doc in Excel
BrowseRegression Analysis4
Multiple Regression Analysis ExcelHow to Do a Multiple Regression Analysis in ExcelMultiple Regression Equation ExcelExcel Regression with Multiple Variables
BrowseSUM5
Adding Text in ExcelAdding Multiple Rows in ExcelExcel SUM Multiple SheetsSUM Text in ExcelHow to SUM Names in Excel
BrowseNew guides and tools, once a month
DE + EN · double opt-in · no spam