Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
3 years ago

Formula help to trim my numbers seperated by a comma

Hi, I have a field [Control Number] that has multiple controls listed and separated by a comma.  I'm looking for a formula that will capture the control number without the comma. Ex [Control Nu...
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago
There is a searchandreplace formula which should be relevant for you

SearchandReplace([Control Number],",","")

------------------------------
Prashant Maheshwari
------------------------------
KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
3 years ago
Thank you, I'll check it out.

------------------------------
Kathy Benjamin
------------------------------