use this instead
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
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!
i think i may of confused you
the BYA003 Would look like
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
First, you acknowledge what Dave has said in his post.
=MID(A1,FIND(" ",A1&" ")+1,255)
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 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.i will get there
There are currently 1 users browsing this thread. (0 members and 1 guests)