[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: remove blanks in a string
I can't comment on Excel.
replace strvar = subinstr(strvar," ","",.)
> 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: