Removing Single Spaces
Cheers Ron,
I knew about the substitute function but (and still cannot get it to work),
but the find/replace does the trick.
You just saved me alot of time.
Thanks again
"Ron Rosenfeld" wrote:
On Mon, 24 Nov 2008 13:12:07 -0800, kris
wrote:
Is it possible to remove single spaces from a line?
eg a UPC
1 22222 33333 1
to
122222333331
=substitute(A1," ","")
or use the Edit/Find & Replace menu option, putting a <space in the Find box,
and nothing in the Replace box.
--ron
|