ExcelBanter - Text length

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text length (https://www.excelbanter.com/excel-discussion-misc-queries/170027-text-length.html)

Gmata

Text length

how can i now the text length of a cell?

Gord Dibben

Text length

In an unused cell enter =LEN(cellref) where cellref is the cell with the text.

Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 17:19:01 -0800, Gmata
wrote:

how can i now the text length of a cell?

All times are GMT +1. The time now is 09:18 AM.