Technical forums » Office applications »
Number of characters in strings (Excel)
Thread poster: ALAIN COTE (X)
ALAIN COTE (X)
ALAIN COTE (X)  Identity Verified
Local time: 11:51
Japanese to French
Nov 11, 2002

When we translate an Excel file for User Interface, the number of characters per cell (string) is generally limited. I would like the number of characters in a cell to appear automatically in the following (right) cell, so I don\'t have to count the characters one by one by myself. It\'s very useful when the file is big... Does anybody know how to do that ?

By the way, I once saw an Excel file with a third cell showing automatically \"OK\" when the number of characters was OK, or \"wro... See more
When we translate an Excel file for User Interface, the number of characters per cell (string) is generally limited. I would like the number of characters in a cell to appear automatically in the following (right) cell, so I don\'t have to count the characters one by one by myself. It\'s very useful when the file is big... Does anybody know how to do that ?

By the way, I once saw an Excel file with a third cell showing automatically \"OK\" when the number of characters was OK, or \"wrong\" when the string was too long. Any idea how to do that in Excel ?

Alain ▲ Collapse
 
Elzbieta Wojcicka
Elzbieta Wojcicka
Netherlands
Local time: 04:51
Dutch to Polish
+ ...
Use formulas Nov 11, 2002

To have the number of characters inserted in cell C1, type there:

=LEN(B1)

whe B1 is the cell from where the characters should be counted.



For checking if the number of characters given in cell C1 doesn\'t exceed the limit given in cell D1 use another formula:

=IF(C1
 
ALAIN COTE (X)
ALAIN COTE (X)  Identity Verified
Local time: 11:51
Japanese to French
TOPIC STARTER
Thanks a lot! Nov 11, 2002

Great !

Elzbieta, you are not only a translator, but a great magician !!!

Alain
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Number of characters in strings (Excel)






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »