Mobile menu

Number of characters in strings (Excel)
Thread poster: ALAIN COTE
ALAIN COTE  Identity Verified
Local time: 10:37
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 \"wrong\" when the string was too long. Any idea how to do that in Excel ?

Alain


Direct link Reply with quote
 

Elzbieta
Netherlands
Local time: 03:37
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


Direct link Reply with quote
 
ALAIN COTE  Identity Verified
Local time: 10:37
Japanese to French
TOPIC STARTER
Thanks a lot! Nov 11, 2002

Great !

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

Alain


Direct link Reply with quote
 


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


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

Number of characters in strings (Excel)

Advanced search






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
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 SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs