Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: TEXT RECOGNITION-helppp

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    INDIA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi
    I have a lot of sheets of text which i have imported a notepad file into excel using the delimiter function and stored in different sheets. now i want to find out the number of cells in each sheet which represent text alone{the problem being i have characters like /,.* and some ascii in them and the text although is occupying individual cells for each word but is spread out throughout the sheets}. i also want to find out how much does each word occupies in terms of bytes in the file if possible

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Skywalker:
    Welcome to the board! You have stated a whopper of a problem. Although you want to have an overview of your entire project, you will naturally have to proceed one step at a time. What step are you having a problem with? If you clearly state what issue you need help for, a lot of people will readily step forward to help you!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    First question > WHY???!!!

    anyhow, a simple macro could scan all the data on each sheet and count non-blank cells and count those that have A-Z characters only, you need to give a bit more detail. Is it an unbroken list, how many columns does it occupy?

    about the file size taken by each word, well, in a text file each character is one byte, so you can calculate the size in bytes just by calculating the length in characters, which you can use LEN for.

    ie.
    cell A1...
    ELEPHANT

    cell A2...
    =LEN(A1)

    will give the value 8, as there are 8 characters in ELEPHANT and so it would take 8 bytes of your text file.

    Keep asking for more detail.

    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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