how to get a word be spread to cells
 

is it possible to get the number of letters of a word ? purpose is i want to get the number of letters including space in a string.

for example the following string is in col A1

101 pari malar i should get 14 in col B1
(3) + (4) + (5) +3 spaces

how to get a word be spread to cells
 

It happens that sumesh56 formulated :
is it possible to get the number of letters of a word ? purpose is i
want to get the number of letters including space in a string.

for example the following string is in col A1

101 pari malar i should get 14 in col B1
(3) + (4) + (5) +3 spaces

In B1:

=LEN(A1)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Hi,

In B1 type =LEN(A1)

DEAR GARRY,
thanks a lot for the direction. it works. have a nice day.

how to get a word be spread to cells
 

sumesh56 formulated on Wednesday :
'GS[_2_ Wrote:
;1601080']It happens that sumesh56 formulated :-
is it possible to get the number of letters of a word ? purpose is i
want to get the number of letters including space in a string.

for example the following string is in col A1

101 pari malar i should get 14 in col B1
(3) + (4) + (5) +3 spaces-

In B1:

=LEN(A1)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

DEAR GARRY,
thanks a lot for the direction. it works. have a nice day.

You're welcome! I appreciate the feedback...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion