Remove Spacing In A Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to eliminate spacing for a upc in a cell. For a example:
0 11111 22222 3
011111222223

I have tried Clean, Trim, & Substitute.

Anyone have any answers or Ideas?

Thanks,
 
For me
A1: 0 11111 22222 3
=SUBSTITUTE(A1," ","")
worked, returned
A1: 011111222223

Regards,
Stefi

„Span†ezt írta:
 
Hi Steffi,
For me
A1: 0 11111 22222 3
=SUBSTITUTE(A1," ","")
worked, returned
A1: 011111222223
Click to expand...

That depends on the nature of the space.Given that Span said:

It would appear possible that the spaces in question are the HTML
non-breaking space character (ASCII code 160).

See the link that I provided in my response to Span. See particularly David
McRitchie's TrimAll Macro and the accompanying notes thereto.
 
Thanks Norman,

I see the point now.

Regards,
Stefi


„Norman Jones†ezt írta:
 
Back
Top