Sort by substring
To sort data by a substring, you can use the SORTBY function together with the TEXTBEFORE and TEXTAFTER functions. In the worksheet shown, we are sorting the codes in column B by color. The formula in cell D5 is: …Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
STOCKHISTORY Function
The Excel STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The primary purpose of STOCKHISTORY is to get the history of a financial instrument over time. The result is an array of values that spill onto the worksheet into multiple cells.Read more
Recent Articles
Combinations and permutations in Excel
Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more
Topics By Category
User Testimonials
Thank you for all the work you do. The help you provide with your page is not only very helpful but very professional and outstanding.
Juan
I just want to send a quick email to thank you for all you do. I've been a subscriber for over a year and have found your website and articles helpful and informative.
Adrienne
Thank you for saving me so much time!
Jenny
Get Training
We offer free resources and paid training.
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.
