Loading
8-Jan PAYPAL MICROPHONE CA 8.99 8.99

Say you have the following excel table and you want to populate the right-most cell with the 8.99 from cell B1.

The function you’ll need is as follows:

=RIGHT(B1,LEN(B1)-FIND(“@”,SUBSTITUTE(B1,” “,”@”,(LEN(B1)-LEN(SUBSTITUTE(B1,” “,””)))/LEN(” “))))

This will get the last string with the right-most space before it.

Leave a Reply

Your email address will not be published. Required fields are marked *

Top