FIND function

[CHuguley]

In using the FIND function, how can I make the it look at the second space in text that I'm extracting from? I'm trying to return the text after the second space in the orginal text.

Thanks

 

[Juan Pablo González]

Something like this ?

=RIGHT(A1,LEN(A1)-FIND(" ",SUBSTITUTE(A1," ","",1))-1)


I'm using the SUBSTITUTE to replace the first space with nothing, and then, use the RIGHT function to extract the right portion of the text...

 

[CHuguley]

What about the left position? How can I accomplish using the LEFT function?

Thanks

 

[Juan Pablo González]

The FIND(..) function I posted in the previous post should give you (-1) the position of the second space in the string of A1, you can use that number to return the text you want.