To post as a guest, your comment is unpublished.· 1 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.
输入这个公式： = TRIM（RIGHT（SUBSTITUTE（A2，“”，REPT（“”，255）），255）） 到想要获得结果的空白单元格中，然后将填充手柄向下拖到要填充此公式的单元格中，并且一次提取满足第一个空格时从单元格中右侧的所有字符，请参见截图：
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
To post as a guest, your comment is unpublished.· 1 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.· 2 months agothanks a lot
To post as a guest, your comment is unpublished.· 2 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.· 2 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.· 3 months agoThank you so much! Saved me a ton of time!