Extract characters from Right - till Space

[stct80]

Can anyone advise on how do I extract characters from right, till space.

Example

For Cell value A1 : ABCD 123E

I want to extract 123E and capture that in another column of the same row (say B1).

Thanks in advance,

 

[VoG]

Try

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[stct80]

Hi VoG,

Tried the formula for cell D5 =RIGHT(D5,LEN(D5)-FIND(" ",D5))

Unfortunately, it pulled the entire string. May be I am missing a small step!

Pls advise,

 

[VoG]

Works here

Excel Workbook
	D	E
5	ABCD 123E	123E
Sheet2

Is it definitely a space or could it be another character (is the data downloaded from the internet - it could be CHAR(160).

 

[stct80]

Hi again,

Here is the string that I want source data from:

DOC: Internal REview -> Orange - MF Doc 55025

This data is copied from a different file format (similar to excel).

I used : =RIGHT(D5,LEN(D5)-FIND(" ",D5))

This is what I got (copied -pasted from cell, as I do not know how to include a screenshot in the forum

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>Internal REview -> Orange - MF Doc 55025</TD></TR></TBODY></TABLE>

Pls advise,

 

[VoG]

Try

=TRIM(RIGHT(SUBSTITUTE(D5," ",REPT(" ",255)),255))

 

[stct80]

That worked perfect! Thank you so much VoG..

 

[TJKawaguchi]

Thanks so much for this!

 

[atx100r]

Try

=TRIM(RIGHT(SUBSTITUTE(D5," ",REPT(" ",255)),255))

Hello VoG..Its been some time since you posted this. I came upon it today and it solved my problem but I do not understand how it works. If you have time can you detail the command for me so I can learn. Thx

 

[Joe4]

but I do not understand how it works. If you have time can you detail the command for me so I can learn.

Basically, you are replacing each space with 255 spaces (so there are a ton of spaces between each word).
Then you are taking the right-most 255 spaces. So, as long as the number of characters after your space is less than 255, this will extract a whole bunch of spaces and your word.
Then, use the TRIM function to get rid of all spaces at the very beginning and very ending of your extracted value. Then you are left with just your word!