Results 1 to 3 of 3
Like Tree1Likes
  • 1 Post By Richard Schollar

Formula to return characters in a cell before a specific character

This is a discussion on Formula to return characters in a cell before a specific character within the Excel Questions forums, part of the Question Forums category; I have a field that is not a fixed length. It contains characters before and after a colon (":") (including ...

  1. #1
    Board Regular
    Join Date
    Nov 2002
    Location
    Tri-Cities, WA
    Posts
    105

    Default Formula to return characters in a cell before a specific character

    I have a field that is not a fixed length. It contains characters before and after a colon (":") (including spaces). I need to eliminate all of the characters after the ":" and just return the characters and spaces before the ":". The number of characters before the ":" varies (or I would just use Left()). Would someone please help me with a formula to return only the characters before the ":"?
    Thank you.
    "God does arithmetic."
    -Karl Friedrich Gauss (1777-1855)

  2. #2
    MrExcel MVP
    Moderator
    Rediscovering the love
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,677

    Default Re: Formula to return characters in a cell before a specific character

    Hi

    You can use Left:

    =LEFT(A1,FIND(":",A1&":")-1)
    solgama likes this.
    Richard Schollar

    Using xl2013

  3. #3
    Board Regular
    Join Date
    Nov 2002
    Location
    Tri-Cities, WA
    Posts
    105

    Default Re: Formula to return characters in a cell before a specific character

    Thank you! I feel kinda dumb because that is a very simple formula. I just could not remember how to identify a spacific character. Thank you so much for taking the time to reply to my banal post.
    "God does arithmetic."
    -Karl Friedrich Gauss (1777-1855)

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
  •  


DMCA.com