TEXT RECOGNITION-helppp

skywalker · Apr 14th, 2002, 07:35 AM

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

Yogi Anand · Apr 14th, 2002, 08:06 AM

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!

daleyman · Apr 14th, 2002, 09:07 AM

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.

Apr 14th, 2002, 08:06 AM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	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

Apr 14th, 2002, 09:07 AM	#3
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	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>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 14th, 2002, 07:35 AM	#1
skywalker New Member Join Date: Apr 2002 Location: INDIA Posts: 2	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