REGEXREPLACE

REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])

Returns the text string after replacing characters that match a regular expression.

text	The text string.
pattern	The regular expression.
replacement	The text you want to replace instances of pattern.
occurrence	(Optional) Which instance of the pattern you want to replace.
case_sensitivity	(Optional) A logical value indicating whether to ignore the case: 0 = Case sensitive (default) 1 = Not case sensitive

REMARKS

* This is a Preview Function which means the signature and results may change before being officially released.
* This function was added in Microsoft 365.
* If "occurrence" is left blank, then 0 is used.
* link - insider.microsoft365.com/en-us/blog/new-regular-expression-regex-functions-in-excel
* You can use the REGEXEXTRACT function to return the characters that match the pattern provided.
* You can use the REGEXTEST function to return True or False depending if the pattern matches any part of a text string.
* This function was first released in June 2024.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=REGEXREPLACE(Mat Taylor (123) 456-7890,"[0-9]+-","*-") = Mat Taylor (123) *-7890

1 - Replace the first three digits with asterisks.