Mobile menu

Number of characters in strings (Excel)
Thread poster: ALAIN COTE
ALAIN COTE  Identity Verified
Local time: 05:27
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: 21:27
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: 05:27
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






SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



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