Differences

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

Link to this comparison view

Both sides previous revision Previous revision
functions:clean_cell [2016/02/16 17:03]
metecuma
functions:clean_cell [2016/02/16 17:04]
metecuma
Line 9: Line 9:
 By using this function, you can remove/​strip/​clean some character groups (letters, digits, non-words etc.) from cell value via Regular Expression.\\ 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 ​has two parameters, mandatory one is //-of course-// cell value which we use. Second and optional one is Character_Group. \\
 At figure below you can see usage and results.\\ At figure below you can see usage and results.\\
 Depending on your needs, you may add extra Character_Group by using Regular Expression. \\ Depending on your needs, you may add extra Character_Group by using Regular Expression. \\