excel - Search a string for certain amount of spaces -

excel - Search a string for certain amount of spaces -

i looking formula allows me search number of " " starting end of text (right) in text string in cell a, , looks on right of text string , search bit of text exact match against text range in column text column b.

if exact match found should pick in corresponding column c , homecoming value. if more 1 match found in column b error should given.

i have next bit of code looks @ 3rd space doesn't homecoming of text on right hand side

=right(b8,search(" ",b8,search(" ",b8,search(" ",b8)+1)+1)-1)

and still require compare text formula cell b , c.

try:

=trim(right(substitute(b8," ",rept(" ",777)),2331))

though i'm not @ clear other parts question. perhaps give examples?

regards

excel