+ Reply to Thread
Results 1 to 2 of 2

Counting number of characters in a cell

  1. #1
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    286

    Counting number of characters in a cell

    Is it any way to count number of characters in a single cell ?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Counting number of characters in a cell

    You can use the LEN function, like this:

    =LEN(A1)

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. counting number of characters in a cell and accordingly using if statement
    By sonu_jain6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2016, 07:13 AM
  2. Counting number of characters between 2 values in string
    By ashraf999 in forum Excel General
    Replies: 3
    Last Post: 01-28-2012, 04:29 AM
  3. Counting the number of characters in a cell
    By Telometricious in forum Excel General
    Replies: 2
    Last Post: 11-22-2011, 10:07 AM
  4. Replies: 5
    Last Post: 06-23-2011, 12:32 PM
  5. Counting the total number of symbols or characters in multiple rows
    By wgwg123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2011, 07:49 PM
  6. counting the number of characters in a cell w text
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2011, 12:59 PM
  7. [SOLVED] counting characters in a cell:return the number
    By Glenn in forum Excel General
    Replies: 3
    Last Post: 08-23-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1