Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to remove a space after a comma in a string

Topic Labels: Formulas
Solved
Jump to Solution
2113 2
cancel
Showing results for 
Search instead for 
Did you mean: 
AJTech
5 - Automation Enthusiast
5 - Automation Enthusiast

This is probably really simple - can someone please help with a formula…

What I am trying to achieve: remove space after comma in a string

Example of existing string: Kim Jones, Ted Jones, Fred Jones, Sam Jones

What I am after is a formula to convert the above to: Kim Jones,Ted Jones,Fred Jones,Sam Jones

I have up to 11 names in my string - any advice is greatly appreciated.

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

This should do it:

SUBSTITUTE({Field name or string}, ", ", ",")

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

This should do it:

SUBSTITUTE({Field name or string}, ", ", ",")

Awesome - perfect thank you!
:white_check_mark: