Announcement

Collapse
No announcement yet.

Extract Text After Space In String

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Extract Text After Space In String

    HI,

    i have used the RIGHT function to remove the 1L/1S and the 1L from the samples belows

    the problem i have is when the 1L is in its cell there are 3 spaces before it
    how can i remove those spaces so that all the data is to the left of the cell

    BYA001 1L/1S
    BYA003 1L

    thanks
    steve

  • #2
    Re: Right Worksheet Function

    use this instead

    =LEFT(A1,FIND(" ",A1)-1)

    Comment


    • #3
      Re: Right Worksheet Function

      Steve, why are you wording your Thread Title with what you THINK is your answer. You are told not to do this is the rules you agreed to AND on the New Thread page you posted from.

      Please start to consider other forum members, not only yourself!

      Comment


      • #4
        Re: Extract Text After Space In String

        HI,

        i think i may of confused you
        the BYA003 Would look like
        BYA001 1L/1S
        BYA003 1L
        not as i have had shown in the previous post

        it is the 1L/1S and the 1L That i need to be in a different cell with no spaces
        so hopefully it would look like this

        1L/1S
        1L

        Comment


        • #5
          Re: Extract Text After Space In String

          Hi,

          First, you acknowledge what Dave has said in his post.


          =MID(A1,FIND(" ",A1&" ")+1,255)
          Kris

          ExcelFox

          Comment


          • #6
            Re: Extract Text After Space In String

            HI,

            thank you,

            dave,

            i thought i had a better attempt at this tittle than the others you said where not discriptive enough. i will get there


            steve

            Comment


            • #7
              Re: Extract Text After Space In String

              Really? The text below that you would have seen didn't give you any hints?

              READ BELOW ELSE YOUR POST WILL BE DELETED. YOU HAVE BEEN WARNED!!

              Your question Title must accurately and concisely describe your problem, NOT what you THINK is your answer. Use only relevant keywords. Be considerate of other Excel users who search. Nothing worse than having to click through all search results to see if it matches your problem!
              i will get there
              I wouldn't count on that. As you know, the rules you agreed to are enforced and high maintenance question askers are not considered contributing forum members.

              Comment

              Working...
              X