Advanced Right

Hi,

To extract the last word in A1,

=MID(SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),FIND("^",SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,256)

Originally Posted by roly

Hi,

I am trying to extract the right hand few characters (pack size) from a cell and can do most of them by finding two spaces because most of them have at least two spaces, using this:

=TRIM(RIGHT(D2,LEN(D2)-FIND(" ",D2)))

From "ECONOMY 32% SAUSAGE 8'S 80-57G"

This works for most of them but some of the pack sizes are only separated by one space and there are always few before, but no fixed amount and the do not work.

What I want to do is run the find part starting from the right hand side and finding the first space, which will always be the correct place to start extracting.

Thanks for your help,


Roly

Please post some more examples of your data with the required outcome.

"ECONOMY 32% SAUSAGE 8'S 80-57G"

what should be the outcome in above example.