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

I don't see a difference between the before and after...

maybe...

=substitute(a1," ","")

or just selecting your range
edit replace
what: (spacebar)
with: (leaveblank)
replace all



Juan wrote:

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

--

Dave Peterson

Juan.

Please try =trim(a1)

To delete blank spaces

Thank you



Juan wrote:
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

--
purplemx

Message posted via http://www.officekb.com