I would like to have a formula that only applies to a cell if another has been filled beforehand.


So cells in the column G might contain a text.

Colum N has to show the number of characters that column G contains (=LEN) but I don't want column N to contain the number 0 if column G has no text. I would rather have column N blank.

The first row 1 does not contain data, it's the titles. And all the following rows are the data. So I had =LEN(G2) for every N cell row with their corresponding G cell number.

Also, I work with the French version of Excel and so I can find the equivalents for the terms but I don't if the punctuation changes across languages... does it?

Can I ask questions about macros in here or not really?

Thank you! :)

Andréa