Hello all,
I have a part field lets say Column A and some parts containn a space in
between some parts. Is there a way to delete the empty space? Here's example:

XX124 TZ I want this to be XX124 TZ
ZZ243 TX I want this to be ZZ243 TX
ZZ356TZ This stays same
xyw3 TZ I want this to be xyw3 TZ

So I just want to delete the spaces.

Please advise any help.

thank you,

Juan