Excel – Select Column to End of Data with Blanks – 3 Methods
Microsoft Excel Tips and Tricks In this video I demonstrate three methods for selecting a column of data that includes[…]
Read more
Tag: excel
Quickly Add Quotation Marks to Text, Number or Dates: Concatenate or Custom Number Format
Microsoft Excel Tips and Tricks In this video I demonstrate how to add quotation marks or speech marks around text,[…]
Read more
Combine Multiple Rows into One Cell, Separated by Comma, Using Excel’s Power Query
Microsoft Excel Tips and Tricks In this video I demonstrate how to combine multiple rows into one cell in Excel,[…]
Read more
Remove First or Last Character From Text String in Excel
Microsoft Excel Tips and Tricks In this video I demonstrate how to remove the first or last character in a[…]
Read more
Excel Lookup and Find the 2nd, 3rd, 4th or Nth Occurrence / Match (Without Using an Array Formula)
Microsoft Excel Tips and Tricks In this video, I demonstrate how to lookup the 2nd, 3rd, 4th or nth occurrence[…]
Read more