Results 1 to 3 of 3

Thread: convert text to numbers

  1. #1
    Seeker Azerin's Avatar
    Join Date
    Mar 2015
    Location
    Azerbaijan
    Posts
    9
    Articles
    0

    convert text to numbers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    May be there is post regarding this topic. But I can't find anything concerning my problem.

    I need to copy table from one web site and proceed with this table in excel. After copying I realize that number are in text format.
    While controlling cells with =istext formula only one cell returns False and All table gives True result.

    I have tried almost every way for converting text to number.
    I use text to column, paste special with add operation (returns empty cells), paste special with multiple operation with 1 (returns the same cells in text format), I have tried several VBA codes...

    The problem still remains as a problem! Please help me with this issue.
    I have attached table for review.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    There is a non-printable character (Ascii code 160) at the end of each cell.

    Go to one of those cells and highlight and copy that last "space".

    Then select the whole table, do a CTRL+H (Find/Replace) and paste what you copied into the find what box. Then just click Replace All.


  3. #3
    Seeker Azerin's Avatar
    Join Date
    Mar 2015
    Location
    Azerbaijan
    Posts
    9
    Articles
    0
    You are Great Thank you very much NBVC.

    Sometimes difficult cases may have very easy solutions

    PS. Before to post this question I have tried to remove that non printable character by clean formula. But it didn't work.

Posting Permissions

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