I have created a calculation field named Number2

I want to use this field to remove all of the puncuation from another field Number1

Both fields are text fields becasue they not only have numbers in the but also have letters somtimes.

 

and example of what is in the field Number1 is 11-44-25-08-000B1.00CE

and I would like the calculation result in Number2 to look like 11442508000B100CE

 

Any help would be greatly appreciated.  I tried all kinds of posts and could not find anything that would remove puncuation from a field containging number and letters.

 

 

This is a problem of definition: you can either remove all punctuation characters, or leave in only alphanumeric characters. Either way, you must make a list of the forbidden/allowed characters. "Punctuation" is a very wide term and so is "alphanumeric".

 

Once you have a list,  use either the Substitute() function to remove the blacklisted characters, or the Filter() function to preserve the white-listed ones.

Never mind, I figured it out.

 

Substitute(Substitute(Number1; "-"; ""); "."; "")