G
Guest
How can I count the number of characters in a cell?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Coderre
With
A1: (a text value)
Try this
B1: =LEN(A1)
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
A1: (a text value)
Try this
B1: =LEN(A1)
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
G
Guest
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.
is showed 28 for a cell that has 10 characters.
G
Guest
What is in cell A1?
Coccoleggs said: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.
G
Guest
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
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
G
Guest
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
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
G
Guest
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 .
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 said: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 said: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.
M
MartinW
Sounds like the non-breaking space problem which
Text to Columns will overcome.
What happens to the original data if you do Edit>Replace
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
Text to Columns will overcome.
What happens to the original data if you do Edit>Replace
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 said: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 said: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 said: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.
:
With
A1: (a text value)
Try this
B1: =LEN(A1)
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
How can I count the number of characters in a cell?
G
Guest
"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
"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 said: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 said: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 said: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.
:
With
A1: (a text value)
Try this
B1: =LEN(A1)
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
How can I count the number of characters in a cell?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.