Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Extract Text After Space In String

1. Senior Member
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. ## Re: Right Worksheet Function

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

Excel Video Tutorials / Excel Dashboards Reports

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!

4. Senior Member
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. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,478

## 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. Senior Member
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. ## 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.

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

#### 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