17 August 2011

Count Characters in Excel

Sometimes it may be handy for you to count how many characters are in a specific cell within Excel.  I was asked this question last night and can confirm that it’s very easy to do.  Basically you’ll want to enter a short operator into the cell you wish the counted figure to go into and reference the cell you wish to count.

They say that a picture speaks a thousand words, and will certainly make this a lot clearer.  Have a look at the screenshot I took below!

No comments:

Post a comment

Please use a Google Account to comment and check the box if you'd like notified of any responses. You can comment with just your name or anonymously if you'd prefer.