ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Count Characters in A Cell (https://www.excelbanter.com/excel-discussion-misc-queries/204618-count-characters-cell.html)

Daren

Count Characters in A Cell
 
I have a text string in a cell and need to count the number of characters in
it. Is there a formula for it?

Thanks.

Bob Flanagan[_2_]

Count Characters in A Cell
 
Use =Len(cell ref)

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Daren" wrote in message
...
I have a text string in a cell and need to count the number of characters
in
it. Is there a formula for it?

Thanks.




Gaurav[_4_]

Count Characters in A Cell
 
=LEN(A1)


"Daren" wrote in message
...
I have a text string in a cell and need to count the number of characters
in
it. Is there a formula for it?

Thanks.




Daren

Count Characters in A Cell
 
Thanks

"Bob Flanagan" wrote:

Use =Len(cell ref)

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Daren" wrote in message
...
I have a text string in a cell and need to count the number of characters
in
it. Is there a formula for it?

Thanks.





Daren

Count Characters in A Cell
 
Thanks

"Gaurav" wrote:

=LEN(A1)


"Daren" wrote in message
...
I have a text string in a cell and need to count the number of characters
in
it. Is there a formula for it?

Thanks.






All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com