Last space in a portion of cell text

[TomH]

Hello all.

I am trying to find a way of writing a formula that will find the last space character in a 26-character section of the text of a single cell. Specifically, I want the formula to give me the position of the last space in characters 1-26, 27-52, etc. I can get the first one, of course, using the SEARCH function and simply setting the starting character. But, how do I find the LAST one in that section of the text?

Any help is appreciated. THANKS!

Tom

 

[DCrake]

You can use the InStrRev() to detect it. Unlike InStr that reads from left to right, InStrRev reads from right to left.

David

 

[TomH]

After reading up, I find that to be a viable solution. Unfortunately, I use VBA in Access, but the closest I have come to VB in Excel is writing a few macros. Looks like I have some self-education to do. Thanks.

 

[namliam]

dont sound like vba is needed a simple instr or instrrev should do the trick for you...