KEEP or PURGE characters from Strings

Receiving data with non numerical characters blocking Excel from doing calculations?


With KEEP, you can define to keep only 0123456789 and thus purge all others. You chose the characters to keep or purge.

  • KEEP (by lambda)
  • PURGE (by lambda)
  • CELLS.DOWN (by lambda)


  • LAMBDA