| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate the sum of characters in a cell
is there a tool to calculate the sum of characters in a cell?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
Can you elaborate? What do you mean? roman numerals? Adding the number of
letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
I think you mean the sum of the digits in the cell, correct?
E.g., if the cell reads 1345, you'd want it to return 13... This macro will help you: https://www.exceltip.com/st/Sum_the_...Excel/620.html Dave -- Brevity is the soul of wit. "tim m" wrote: Can you elaborate? What do you mean? roman numerals? Adding the number of letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
thank you for your reply
I'm looking to calculate how much alphabetical characters I have in each cell "tim m" wrote: Can you elaborate? What do you mean? roman numerals? Adding the number of letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
Oh, then just do =LEN(A1), etc.
Dave -- Brevity is the soul of wit. "Nat" wrote: thank you for your reply I'm looking to calculate how much alphabetical characters I have in each cell "tim m" wrote: Can you elaborate? What do you mean? roman numerals? Adding the number of letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
Thanks, this is what I'm looking for
"Dave F" wrote: Oh, then just do =LEN(A1), etc. Dave -- Brevity is the soul of wit. "Nat" wrote: thank you for your reply I'm looking to calculate how much alphabetical characters I have in each cell "tim m" wrote: Can you elaborate? What do you mean? roman numerals? Adding the number of letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
FWIW, in Excelese, this formula could provide the COUNT of the number of
characters in a cell, rather than their SUM.......... Vaya con Dios, Chuck, CABGx3 "Nat" wrote: Thanks, this is what I'm looking for "Dave F" wrote: Oh, then just do =LEN(A1), etc. Dave -- Brevity is the soul of wit. "Nat" wrote: thank you for your reply I'm looking to calculate how much alphabetical characters I have in each cell "tim m" wrote: Can you elaborate? What do you mean? roman numerals? Adding the number of letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
I dont see any function named FWIW
"CLR" wrote: FWIW, in Excelese, this formula could provide the COUNT of the number of characters in a cell, rather than their SUM.......... Vaya con Dios, Chuck, CABGx3 "Nat" wrote: Thanks, this is what I'm looking for "Dave F" wrote: Oh, then just do =LEN(A1), etc. Dave -- Brevity is the soul of wit. "Nat" wrote: thank you for your reply I'm looking to calculate how much alphabetical characters I have in each cell "tim m" wrote: Can you elaborate? What do you mean? roman numerals? Adding the number of letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the sum of characters in a cell
FWIW is not an excel function. It means "for what it's worth."
-- Brevity is the soul of wit. "Nat" wrote: I dont see any function named FWIW "CLR" wrote: FWIW, in Excelese, this formula could provide the COUNT of the number of characters in a cell, rather than their SUM.......... Vaya con Dios, Chuck, CABGx3 "Nat" wrote: Thanks, this is what I'm looking for "Dave F" wrote: Oh, then just do =LEN(A1), etc. Dave -- Brevity is the soul of wit. "Nat" wrote: thank you for your reply I'm looking to calculate how much alphabetical characters I have in each cell "tim m" wrote: Can you elaborate? What do you mean? roman numerals? Adding the number of letters in a cell? Can you give us an example of your data? "Nat" wrote: is there a tool to calculate the sum of characters in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| remove last three characters of cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| if cell starts with characters formula | Excel Discussion (Misc queries) | |||
Linear Mode
