If Microsoft Excel does not recognize dates, then there is something wrong with the formatting. Use any of the methods mentioned here to format cells perfectly.

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 ...

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.

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 ...