I have two possible types of text string in Excel, either DA3-AJ33S-5P1 or DA3-AJ150S-5P1. I want a formula that extracts the middle part of the text string i.e. the "AJ33S" or the "AJ150S" - the ...

Q. I receive Excel spreadsheets regularly that contain dates. I have to manually look up the day of the week that represents these dates. Are there any functions that can help speed this process along ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.