Formula to Pull Data from Right of Cell Until Designated Space

October 12, 2016

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

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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