Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding the total # of characters in multiple cells
Two things I would like to automate:
I need to add the total number of characters in up to 5 cells to know that they do not exceed 75 characters total. Anyone know how I can do this? Example: character count in cells B, D, F, H, J = total # of characters used Also, I would like to just be able to click on a cell and see how many characters are in that cell, or at least know that it is less than 285 characters. These are easy to do in Word with the tool word count, is there anything like it in Excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
How do I get a total adding cells from other sheets for a roll-up | Excel Worksheet Functions | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |