If cell A1 contains "Jon Doe," it is corrected to "John Doe." Replace "start_number" with "FIND (find_text,source)" without quotes to locate the starting position for the "Replace" function.

Q. I use a spreadsheet that includes a list of machine parts identified by both words and numbers—for example, Part 2312. Since the cells contain both text and numbers, how can I sort them in ...

If a cell contains text, blank space or any other non-number, it is not counted. This function uses the format COUNT (Value1, Value2,…Value [n]), where "n" is limited to a maximum of 255.

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

None of the spaces here are required. As you can see in the screenshot below, the formula works without these spaces. You can access an Excel workbook and accompanying video below for combining a ...