I want to change Variables through built-in function (replace)
I want to put a comma between the every collected digits by called user.
ex.)
- “$(cbPhoneX)” is collected digits by called user.
→ =replace("$(cbPhoneX)", “???”, “???”, “ig”)
I want to change Variables through built-in function (replace)
I want to put a comma between the every collected digits by called user.
ex.)
→ =replace("$(cbPhoneX)", “???”, “???”, “ig”)
=replace("$(cbPhoneX)", “”, “,”, “ig”)
Not sure “” would match anything.
In case it doesn’t:
=replace("$(cbPhoneX)", “(\d)”, “\1,”, “ig”)
Thank you for replying