I use Excel spreadsheets for entering data for a character generator at my TV station (WKYC-TV, Cleveland). The result is a crawl of information at the bottom of the screen, like you see on CNN, FOX, etc.
Usually, this works with out a problem. The producers enter this crawl information into specific cells, which I have formatted to turn red if they enter more than 255 characters of information (mainly because that's about as much as a person can read before losing their place).
Here's the problem:
The character generator (by Chyron) accepts characters with a decimal value from 3 to 191 as valid characters. If the decimal value is higher, the data is interpreted as commands, ranging from changing the speed to terminating the crawl.
I want to filter each of these cells so that only acceptable characters are sent (decimal 3 to 191) and it must be done as soon as the producer hits Enter.
The range is F2:F500.
Thanks for any help
Usually, this works with out a problem. The producers enter this crawl information into specific cells, which I have formatted to turn red if they enter more than 255 characters of information (mainly because that's about as much as a person can read before losing their place).
Here's the problem:
The character generator (by Chyron) accepts characters with a decimal value from 3 to 191 as valid characters. If the decimal value is higher, the data is interpreted as commands, ranging from changing the speed to terminating the crawl.
I want to filter each of these cells so that only acceptable characters are sent (decimal 3 to 191) and it must be done as soon as the producer hits Enter.
The range is F2:F500.
Thanks for any help