Formula to Pull Data from Right of Cell Until Designated Space
top of page
Search
    • Oct 12, 2016

Formula to Pull Data from Right of Cell Until Designated Space


You can use this Excel formula to pull data from the right side of a cell until the character specified in quotes before REPT appears in the referenced cell. So if you have data in A1 and enter the formula in B1 . .

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

. . . it will pull out the text until the first space appears moving from right to left.


bottom of page