Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Extract Text After Space In String

  1. #1
    Join Date
    12th August 2006
    Posts
    181

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th July 2004
    Posts
    1,353

    Re: Right Worksheet Function

    use this instead

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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    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!

  4. #4
    Join Date
    12th August 2006
    Posts
    181

    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

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,340

    Re: Extract Text After Space In String

    Hi,

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


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

  6. #6
    Join Date
    12th August 2006
    Posts
    181

    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

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    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.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: October 19th, 2011, 03:27
  2. Extract Part Of Text String
    By suaiko9999 in forum EXCEL HELP
    Replies: 34
    Last Post: August 17th, 2007, 16:52
  3. Extract Text From String-vba
    By krishna.a in forum EXCEL HELP
    Replies: 2
    Last Post: May 2nd, 2007, 22:43
  4. Extract Text From a String
    By jonny in forum EXCEL HELP
    Replies: 8
    Last Post: October 4th, 2006, 19:36
  5. Detect space, underscore or semi-colon in text string
    By Maths Dude in forum EXCEL HELP
    Replies: 9
    Last Post: January 31st, 2005, 09:52

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
  •  
porno