Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
How can I count the number of characters in a cell?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
With
A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
That did not work. But thats for the suggestion. When I put the formula in
is showed 28 for a cell that has 10 characters. "Ron Coderre" wrote: With A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
What is in cell A1?
"Coccoleggs" wrote: That did not work. But thats for the suggestion. When I put the formula in is showed 28 for a cell that has 10 characters. "Ron Coderre" wrote: With A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
I hate to disagree, but if the LEN function says you have 28
characters....then you HAVE 28 characters. What are the actual contents of that cell? Try this to test..... Select the cell in question Press [F2]...to engage Edit Mode If that cell contains a formula Press [F9]...to convert the formula to its calculated value. Now count the characters displayed in the formula bar. Are there blanks that you hadn't considered? Does that help? *********** Regards, Ron XL2003, WinXP "Coccoleggs" wrote: That did not work. But thats for the suggestion. When I put the formula in is showed 28 for a cell that has 10 characters. "Ron Coderre" wrote: With A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
In the a column there are descriptions of materials that I need to cut down
to only 60 characters. I did find a way around it. I put 61 characters in a cell, highlighted the whole column, then went to text to column, then i put the cursor between the 60 and 61 characters. I filtered out all the cells with more than 60 characters. Its not a formula but it works "Sandy" wrote: What is in cell A1? "Coccoleggs" wrote: That did not work. But thats for the suggestion. When I put the formula in is showed 28 for a cell that has 10 characters. "Ron Coderre" wrote: With A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
the content of the cell was "plexiglass"
the second cell said "tape, cables, AV tape, misc. cables" and it said both cells had 28 characters in it. But the text to column thing worked it separated the 60 characters out . "Ron Coderre" wrote: I hate to disagree, but if the LEN function says you have 28 characters....then you HAVE 28 characters. What are the actual contents of that cell? Try this to test..... Select the cell in question Press [F2]...to engage Edit Mode If that cell contains a formula Press [F9]...to convert the formula to its calculated value. Now count the characters displayed in the formula bar. Are there blanks that you hadn't considered? Does that help? *********** Regards, Ron XL2003, WinXP "Coccoleggs" wrote: That did not work. But thats for the suggestion. When I put the formula in is showed 28 for a cell that has 10 characters. "Ron Coderre" wrote: With A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
Sounds like the non-breaking space problem which
Text to Columns will overcome. What happens to the original data if you do EditReplace Find what: Alt+0160 Replace with: leave this box blank Click Replace All Will the LEN function now give results that you would expect to see. Regards Martin "Coccoleggs" wrote in message ... the content of the cell was "plexiglass" the second cell said "tape, cables, AV tape, misc. cables" and it said both cells had 28 characters in it. But the text to column thing worked it separated the 60 characters out . "Ron Coderre" wrote: I hate to disagree, but if the LEN function says you have 28 characters....then you HAVE 28 characters. What are the actual contents of that cell? Try this to test..... Select the cell in question Press [F2]...to engage Edit Mode If that cell contains a formula Press [F9]...to convert the formula to its calculated value. Now count the characters displayed in the formula bar. Are there blanks that you hadn't considered? Does that help? *********** Regards, Ron XL2003, WinXP "Coccoleggs" wrote: That did not work. But thats for the suggestion. When I put the formula in is showed 28 for a cell that has 10 characters. "Ron Coderre" wrote: With A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Charaters
"Plexiglass" is 10 characters
"tape, cables, AV tape, misc. cables" is 35 characters So a returned value of 28 is incorrect in both cases. What you're describing suggests that you may have Calculation set to MANUAL. If that's the case...when you copy a formula to another cell, it will retain it's previous value. If you press [F9] and the formulas change to correct values... fix it this way: From the Excel main menu: <tools<options<calculation tab Check: Automatic.......Click [OK] Does that help? *********** Regards, Ron XL2003, WinXP "Coccoleggs" wrote: the content of the cell was "plexiglass" the second cell said "tape, cables, AV tape, misc. cables" and it said both cells had 28 characters in it. But the text to column thing worked it separated the 60 characters out . "Ron Coderre" wrote: I hate to disagree, but if the LEN function says you have 28 characters....then you HAVE 28 characters. What are the actual contents of that cell? Try this to test..... Select the cell in question Press [F2]...to engage Edit Mode If that cell contains a formula Press [F9]...to convert the formula to its calculated value. Now count the characters displayed in the formula bar. Are there blanks that you hadn't considered? Does that help? *********** Regards, Ron XL2003, WinXP "Coccoleggs" wrote: That did not work. But thats for the suggestion. When I put the formula in is showed 28 for a cell that has 10 characters. "Ron Coderre" wrote: With A1: (a text value) Try this B1: =LEN(A1) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Coccoleggs" wrote in message ... How can I count the number of characters in a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting | Excel Worksheet Functions | |||
Counting | Excel Worksheet Functions | |||
counting | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |