which replaces the first 24 characters in the text with an empty string (""). The REPLACE function can handle this easily, we just need to provide a cell reference (B6), a starting position (1), the number of characters to replace (24), and the text to use for replacement (""): For replacement, we use an empty string ("") which causes REPLACE to replace characters 1-24 with nothing.

Alternative with SUBSTITUTE

Since the text in this case never varies, we could also use the the SUBSTITUTE function to perform the name operation:

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.