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
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