Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: LEN()?

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way of counting the number of characters in multipal cells

    i.e. =LEN(I7:K7)

    Thanks

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,657
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-02-26 02:38, Ian Mac wrote:
    Is there a way of counting the number of characters in multipal cells

    i.e. =LEN(I7:K7)

    Thanks
    Hi Ian,

    =SUMPRODUCT(LEN(I7:K7))

    Aladin

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Many Thanks Aladin,

    Can't see the wood for the trees today.

    Thanks again

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Again Thank Aladin,

    thought I'd show off and let you see what you helped me with.
    It's a formula separate (eg):

    A Place/Operations Agent/Dummy Project/Data Capture/John Smith/AAA/T1

    I used:

    =LEFT(E7,FIND("/",E7)-1) Standard stuff

    then:

    =LEFT(MID($E9,(SUMPRODUCT(LEN($F9:F9))+COUNTA($F9:F9))+1,100),FIND("/",MID($E9,(SUMPRODUCT(LEN($F9:F9))+COUNTA($F9:F9))+1,100))-1)

    to just drag across.

    Thanks I feel good now.

    Ian

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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