I can't comment on Excel.
replace strvar = subinstr(strvar," ","",.)
Nick
[email protected]
Oleksandr Shepotylo
> 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/
