[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: remove blanks in a string
Nick Cox gave you the Stata approach; in Excel it is similar:
where cellref has the text you wish to fix.
----- Original Message -----
From: "Oleksandr Shepotylo" <email@example.com>
To: "statalist hsphsun2.harvard.edu" <firstname.lastname@example.org>
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.
> * 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: