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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding the total # of characters in multiple cells
Hi
This shouls work for the first part, you could try using conditional formatting for the 285 =LEN(B19)+LEN(D19)+LEN(F19)+LEN(H19)+LEN(J19) Regards Rajesh Mehmi "SAMCAT" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding the total # of characters in multiple cells
Hi
Take a look at the LEN function =LEN(A1) will return the number of characters in cell A1 -- Regards Roger Govier "SAMCAT" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding the total # of characters in multiple cells
Hi,
because the cells are in every other column, and lets say on row 1 you can use the following: =SUMPRODUCT(LEN(B1:J1)*(MOD(COLUMN(B1:J1),2)=0)) As for a word count by clicking a cell - if you want that you will need code. Suppose you want this for all sheets in the workbook: Add this code to the thisWorkbook object in the VBE: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) If ActiveCell < "" Then MsgBox Len(ActiveCell), vbDefaultButton1 + vbInformation, "Character Count:" End If End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SAMCAT" wrote: 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? |
Reply |
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) |