Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    What's in column B?

    (posted incorrectly here...but, don't know how to delete a post)

    I've tried multiplying by 1 (no luck).
    I've tried CLEAN and TRIM and both of them together (no luck).

    What is going on with column B that I can't get them to be REAL numbers?

    I ended up doing: =CODE(left(b1,1)) and found it was character 160 (whatever that is).
    Then, substituted CHAR(160) with a "" .

    Is that the only way??
    Last edited by kweaver; 2012-07-11 at 20:19.

  2. #2
    New Lounger
    Join Date
    Sep 2010
    Location
    Saudi
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts

    "...With a latin based alphabet character number 160 is...

    "...With a latin based alphabet character number 160 is a no-break space..."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •