To post as a guest, your comment is unpublished.· 4 months agoHello, Russell,
If you need the result as number format, you should copy and paste the formula cells into other cells as values, and then convert the text format number to real number.
How to pull or extract characters from right to left in a cell until a space is reached in Excel?
This article will talk about pulling or extracting characters from right in a cell until a space is reached to get the following result in Excel worksheet. A useful formula in this article can solve this job quickly and easily.
Here is a simple formula can help you to extract the characters from right from cell until a space is met, please do as this:
Enter this formula: =TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255)) into a blank cell where you want to get the result, and then drag the fill handle down to cells which you want to fill this formula, and all characters from right in cells when meeting the first space are extracted at once, see screenshot:
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 4 months agoIs there a way to extract and the result be read as a number? I am extracting the number part of an exported column that excel is reading as text. Thanks!
To post as a guest, your comment is unpublished.· 4 months agothanks a lot
To post as a guest, your comment is unpublished.· 5 months agoThis formula worked perfectly:
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255))
Is there any way to do the same thing, but to pullout text from right to left untill the SECOND space?
To post as a guest, your comment is unpublished.· 4 months agoHi, Paulius,
To extract the text from right to left until the second space, you should apply the below formula:
=MID(A2,FIND("@",SUBSTITUTE(A2," ","@",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))-1))+1,100)
Please try, hope it can help you!
To post as a guest, your comment is unpublished.· 5 months agoThank you so much! Saved me a ton of time!