| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Quote:
In B1 type =LEN(A1) |
|
#4
|
|||
|
|||
|
Quote:
thanks a lot for the direction. it works. have a nice day. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy excel spread sheet & graph to word doc without formulas | Excel Worksheet Functions | |||
| How do I embed a word doument in an excel spread sheet? | Excel Discussion (Misc queries) | |||
| Is there an easy way to take data from a spread sheet and have it entered into a Word document? | New Users to Excel | |||
| How do you add an Excel spread sheet to a Microsoft Word report? | Excel Worksheet Functions | |||
| how can I get a formula into a word document from an excel spread | Excel Worksheet Functions | |||
Linear Mode
