Trimming 1 space at end of text string to create a number.

[Wingz]

I inherited a worksheet that has obviously been imported from some other Dbase format. Every single number has a " " (space) behind it, making it text. I tried using trim and Rtrim to get that space out so the value would be a number again, but it does not work. Can anyone help me out on this one?

 

[Paul-Johnson]

Try this:

=Value(Trim(a1))

 

[Mark W.]

If you already tried TRIM it probably isn't a space. Use =CODE(RIGHT(A1)) (where A1 contains one of your "numbers") to pick out this character. Click on the formula bar after selecting the cell containing =CODE(RIGHT(A1)) and press F9. What's the ASCII number that's displayed?

Also, consider using =LEFT(A1,LEN(A1)-1)+0 to trim and convert your "number".>
This message was edited by Mark W. on 2002-03-06 10:56