Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
functions:clean_cell [2016/02/16 16:55]
metecuma
functions:clean_cell [2016/02/16 17:03]
metecuma
Line 7: Line 7:
 === Clean Cell === === Clean Cell ===
 ---- ----
-By using this function, you can remove/​strip/​clean some character groups (letters, digits, non-words etc.) from cell value. \\+By using this function, you can remove/​strip/​clean some character groups (letters, digits, non-words etc.) from cell value via Regular Expression.\\
   =CleanCell(Value,​ Character_Group)   =CleanCell(Value,​ Character_Group)
 The function uses two parameters, mandatory one is //-of course-// cell value which we use. Second and optional one is Character_Group. \\ The function uses two parameters, mandatory one is //-of course-// cell value which we use. Second and optional one is Character_Group. \\