Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: making sure a cell is empty

  1. #11
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The TRIM function removes non-printing characters such as spaces and paragraph returns. But it only removes them before and after *real* characters, and not from in between *real* characters.

    _________________
    TheWordExpert

    [ This Message was edited by: Dreamboat on 2002-02-23 11:50 ]

  2. #12
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-02-23 11:49, Dreamboat wrote:
    The TRIM function removes non-printing characters such as spaces and paragraph returns. But it only removes them before and after *real* characters, and not from in between *real* characters.


    [ This Message was edited by: Dreamboat on 2002-02-23 11:50 ]

    Enter in A1:B1 the following:

    {" ",
    2}

    That is, a space in A1 and 2 in B1.

    In C1 enter:

    ="|"&TRIM(A1)&"|"&TRIM(B1)

    Please report back the result in C1.


    [ This Message was edited by: Aladin Akyurek on 2002-02-28 16:32 ]

    [ This Message was edited by: Aladin Akyurek on 2002-02-28 16:33 ]

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
  •