Remember Me?

 Larry Wallis Posts: n/a Calculating number of letters in a string ...

Looking for a way to calculate the number of characters in a text string. I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.

 Ragdyer Posts: n/a Try this:

=LEN(SUBSTITUTE(A1," ",""))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Larry Wallis" wrote in message
...
Looking for a way to calculate the number of characters in a text string.

I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.

 Geovas Posts: n/a suppose the Word "News Group" is in cell A1 use the following formula in B1:
=LEN(SUBSTITUTE(A1," ",""))

This will first substitute all spaces in the string with nothing and then
return the length of the new string giving you the desired length.... Hope this Helps

Ï "Larry Wallis" Ýãñáøå óôï ìÞíõìá
...
Looking for a way to calculate the number of characters in a text string.

I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.

 Larry Wallis Posts: n/a Thanx RD.

Larry.

"Ragdyer" wrote in message
...
Try this:

=LEN(SUBSTITUTE(A1," ",""))
--
HTH,

RD

--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------

-

"Larry Wallis" wrote in message
...
Looking for a way to calculate the number of characters in a text

string.
I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using

the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.

 Larry Wallis Posts: n/a And thanx to u too Geovas.

Larry.

"Geovas" wrote in message
...
suppose the Word "News Group" is in cell A1 use the following formula in

B1:
=LEN(SUBSTITUTE(A1," ",""))

This will first substitute all spaces in the string with nothing and then
return the length of the new string giving you the desired length.... Hope this Helps

Ï "Larry Wallis" Ýãñáøå óôï ìÞíõìá
...
Looking for a way to calculate the number of characters in a text

string.
I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using

the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Larry Wallis Excel Discussion (Misc queries) 4 February 17th 05 10:11 AM Jog Dial Excel Discussion (Misc queries) 3 January 14th 05 03:44 AM Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM Gabriel Excel Worksheet Functions 2 November 25th 04 04:17 PM Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM

All times are GMT +1. The time now is 08:39 PM. Copyright ©2004-2021 ExcelBanter.