• Effective immediately we will be deleting, without notice, any negative threads or posts that deal with the use of encryption and streaming of scanner audio.

    We've noticed a huge increase in rants and negative posts that revolve around agencies going to encryption due to the broadcasting of scanner audio on the internet. It's now worn out and continues to be the same recycled rants. These rants hijack the threads and derail the conversation. They no longer have a place anywhere on this forum other than in the designated threads in the Rants forum in the Tavern.

    If you violate these guidelines your post will be deleted without notice and an infraction will be issued. We are not against discussion of this issue. You just need to do it in the right place. For example:
    https://forums.radioreference.com/rants/224104-official-thread-live-audio-feeds-scanners-wait-encryption.html

Microsoft Excel, How to limit the number of spaces in a colum

Status
Not open for further replies.

Grog

Completely Banned for the Greater Good
Banned
Joined
Dec 19, 2002
Messages
2,959
Location
West of Charlotte NC
How to limit the number of spaces in Microsoft Excel?

I'm sure there are some excel experts here.

I'm finding that's it a lot easier to setup large trunking systems in excel, then to win97. I finally figured out how to add decimal places after numbers, so that cleared up by TG ID problem. Now i need to know how to limit a colum to 16 spots for my alphatags.

Thanks.
 

mam1081

Member
Joined
Dec 19, 2002
Messages
1,050
Location
Next to a scanner...
I usually make mine turn bold red if it's more than a certain number of characters.

Here's how I do it:

Select the first cell of your "text" range (usually the 1st entry).
Goto "Format" -> "Conditional Formatting"
Change the drop down from "Cell Value is" to "Formula is".
Enter "=LEN(D4)>16" in the box (assuming D4 is your first cell).
Click the format button to change how you want the "errored" cells to display.
Click ok and try it out!

If it works, just click and drag from the lower right corner of that cell all the way to the end of your column of text inputs (it will copy the text that you have in that cell also).
 

Grog

Completely Banned for the Greater Good
Banned
Joined
Dec 19, 2002
Messages
2,959
Location
West of Charlotte NC
mam1081 said:
I usually make mine turn bold red if it's more than a certain number of characters.

Here's how I do it:

Select the first cell of your "text" range (usually the 1st entry).
Goto "Format" -> "Conditional Formatting"
Change the drop down from "Cell Value is" to "Formula is".
Enter "=LEN(D4)>16" in the box (assuming D4 is your first cell).
Click the format button to change how you want the "errored" cells to display.
Click ok and try it out!

If it works, just click and drag from the lower right corner of that cell all the way to the end of your column of text inputs (it will copy the text that you have in that cell also).
Thanks, I was really hoping for a step by step explainatuion. i kinda figured it would not be so hard, just one of those "Duh" moments.

I'll try it out Friday night when I get back to work, and i have time to play on my laptop.
 
Status
Not open for further replies.
Top