how to get a word be spread to cells

[sumesh56]

is it possible to get the number of letters of a word ? purpose is
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 space

 

[GS]

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

 

[Spencer101]

is it possible to get the number of letters of a word ? purpose is
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

Hi,

In B1 type =LEN(A1

 

[sumesh56]

;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

 

[GS]

sumesh56 formulated on Wednesday :

;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