Text lengths functions

O

OverAC

Dear All,

Could you please help me to calculate the length of a text. I have some
text input in a cell and I want to know if it will be truncated and
seperated into 2 line (wrap_text property is true). I want to control
it, please advice me solutions.
Ah. One more question, Can we get a function that make a new line in
cell:
For Ex: We have "Text1" in cell A1, "Text2" in cell A2 and we want
result like this in cell A3:
"Text1
Text2"

Thanks for any help.

OverAC
 
P

Pete_UK

You can use the function LEN( ) to determine how many characters are in
a string.

You can use this formula in A3 to get the result you require:

=A1 & CHAR(10) & A2

Hope this helps.

Pete
 
O

OverAC

Sorry that I might cause misunderstanding,

I meant the physical length of the text not how many character in that
text. I know it depend on many factors but I want to cover them all to
calculate the physical length of the text. These factors maybe: font,
type of the printer, scale of paper size...

Please help me to find the way.

OverAC
 
R

Rithy Chhan

=len("name of cell"), For example =len(a1)

Another one, you can use =a1&a2

Hope this can help you!
 
O

OverAC

I can't beleive that my English were so bad that none understand me.

Pleazzzzzzzzzzzzzzzzz.
 
Top