RegEx Replace

[RMcB]

Hi everyone, 

I have a field called "Accountable User" in a spreadsheet and I need to cleanse a few values. I've never used this function before and need help with the code. 

A few names have an unnecessary white space after a hyphen (e.g., Smith- Jackson, Maria). I want to remove the space between the hyphenated last name. 

Thank you!

[MarqueeCrew · Accepted solution]

@RMcB ,

 why not just:

replace([field], "- ", '-')

 cheers,

mark

[echuong1 · Accepted solution]

You can use a replace statement to remove the instances of "- " and replace it with "-".

[RMcB]

Thank you!!