Delete a Space from Value

[microwin88x]

Hello,

I have a field with NAME where I could get from data:

JOHNSON , JACK (with space after lastname)

JOHNSON, JACK

Is there any way to use a function in JOHNSON , JACK in order to delete that space?

Thank you!

[Anonymous]

Try

replace(NAME, ' ,', ',')

[maxgro]

replace function

=replace('JOHNSON , JACK', ' ,', ',')