Formula to Pull Data from Right of Cell Until Designated Space
Search

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.

Thanks to VoG for posting this formula here: http://www.mrexcel.com/forum/excel-questions/466176-extract-characters-right-till-space.html


0 views
Some elements on this page did not load. Refresh your site & try again.

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com