=LAMBDA(string, RemoveChars(string, remove numbers from text strings, we've created one more function named RemoveNumbers: To delete special characters, we've created a custom function named RemoveSpecialChars: To delete a predefined set of characters from multiple cells, you can create another LAMBDA that calls the main RemoveChars function and specify the undesirable characters in the 2 nd parameter. And due to support for dynamic arrays, the formula spills automatically into all the referenced cells: Since the formula is entered only in the top-most cell, you needn't worry about locking the cell coordinates - a relative reference (D2) works fine in this case. To clean multiple cells with a single formula, supply the range A2:A6 for the 1st argument:
0 Comments
Leave a Reply. |