Wednesday, 29 January 2020

How to filter special Character from a Column in Google Sheet

=REGEXREPLACE(Raaw_data!H1622, "[A-Za-z0-9]", "")

 it will return any special character within the specific cell,

 I got return

-

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)