Nick Cox gave you the Stata approach; in Excel it is similar:
=SUBSTITUTE(cellref," ","")
where cellref has the text you wish to fix.
----- Original Message -----
From: "Oleksandr Shepotylo" <[email protected]>
To: "statalist hsphsun2.harvard.edu" <[email protected]>
Sent: Thursday, April 08, 2004 11:00 AM
Subject: st: remove blanks in a string
> Dear statalist,
>
> Probably very simple question, but I could not find simple solution:
>
> I need to remove blanks in strings of the folloving structure:
> "xxxxxxxxx x", where x is a simbol. It might be helpful to mention that
> simbols are actually numbers.
> I tried to do it in Excel that is supposed to be very simple, but it
> deletes zeroes in the beginning or end of the strings even though I
> mentioned that they should be treated as text.
>
> Oleksandr.
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
