Add last word from a string to the beginning of new string

Here is what I would like to do. Just started researching this but I know there are some pretty smart folks on here who might already know it, so here goes.

Take the last word from string C2 and add it to the beginning of string E2 followed by a space (" "), IF the total number of combined characters does not exceed 24 in length.

ie.
C2 = "AM 63/37 032 P3 Telecore+"
E2 = "5lb SO"
Combined string would read "Telecore+ 5lb SO" since total length is <=24 characters.

Or
C2 = "AM 63/37 032 P3 Telecore+"
E2= "5lb SO; 4000/RL 10RL/CA"
No string would place because the combined string would exceed 24 characters.

Hope that is clear. Thanks for any help and advice.

Try:

Please Login or Register  to view this content.

Slight variation on the same theme:

Please Login or Register  to view this content.

however, like NBVC I can't think of a quick way of avoiding the double evaluation of the final string in a single cell formula...

Originally Posted by DonkeyOte

Slight variation on the same theme:

Please Login or Register  to view this content.

This one did it! I couldn't get the first code to work, but this one is exactely what I need. Thank you both for the input, good stuff.